Title: database updating
Last modified: September 9, 2023

---

# database updating

 *  [samerhouri](https://wordpress.org/support/users/samerhouri/)
 * (@samerhouri)
 * [2 years, 9 months ago](https://wordpress.org/support/topic/database-updating/)
 * Hi, I need help updating the database , while migrating my website to a new hosting,
   because i faced so many problems , I have made a new wordpress installation and
   i updated the databse , but it doesn’t seem to be working that way
 * table prefix is set to $table_prefix = ‘wp1_’;
 * when i change it to $table_prefix = ‘wp_hkhs_’;
 * the website goes offline
 * The page I need help with: _[[log in](https://login.wordpress.org/?redirect_to=https%3A%2F%2Fwordpress.org%2Fsupport%2Ftopic%2Fdatabase-updating%2F%3Foutput_format%3Dmd&locale=en_US)
   to see the link]_

Viewing 7 replies - 1 through 7 (of 7 total)

 *  Thread Starter [samerhouri](https://wordpress.org/support/users/samerhouri/)
 * (@samerhouri)
 * [2 years, 9 months ago](https://wordpress.org/support/topic/database-updating/#post-17038099)
 * I forgot to mention that I am looking to retreive my old contents
 *  Moderator [t-p](https://wordpress.org/support/users/t-p/)
 * (@t-p)
 * [2 years, 9 months ago](https://wordpress.org/support/topic/database-updating/#post-17038142)
 * > while migrating my website to a new hosting
 * WordPress has documentation on moving a site: [ Moving WordPress](https://wordpress.org/support/article/moving-wordpress/)
   
   Didi you follow that guide?
 * > I have made a new wordpress installation and i updated the databse , but it
   > doesn’t seem to be working that way
 * From what version of WP to what version have you moved your database?
 * The reason I asked is because the database ( DB ) structure often changes between
   versions. The implication is that, for example, one cannot import a pre 5x database
   into a 6x install and expect it to work. You need to install your original version
   of WordPress, import your db dump and then start upgrading.
    -  This reply was modified 2 years, 9 months ago by [t-p](https://wordpress.org/support/users/t-p/).
 *  Thread Starter [samerhouri](https://wordpress.org/support/users/samerhouri/)
 * (@samerhouri)
 * [2 years, 9 months ago](https://wordpress.org/support/topic/database-updating/#post-17038152)
 * maybe this will help :
 * wp_hkhs_users: Table ‘samerhouri_herbfits.wp_hkhs_users’ doesn’t exist
   wp_hkhs_usermeta:
   Table ‘samerhouri_herbfits.wp_hkhs_usermeta’ doesn’t existwp_hkhs_posts: Table‘
   samerhouri_herbfits.wp_hkhs_posts’ doesn’t existwp_hkhs_postmeta: Table ‘samerhouri_herbfits.
   wp_hkhs_postmeta’ doesn’t existwp_hkhs_terms: Table ‘samerhouri_herbfits.wp_hkhs_terms’
   doesn’t existwp_hkhs_term_taxonomy: Table ‘samerhouri_herbfits.wp_hkhs_term_taxonomy’
   doesn’t existwp_hkhs_term_relationships: Table ‘samerhouri_herbfits.wp_hkhs_term_relationships’
   doesn’t existwp_hkhs_termmeta: Table ‘samerhouri_herbfits.wp_hkhs_termmeta’ doesn’t
   exist
 *  Thread Starter [samerhouri](https://wordpress.org/support/users/samerhouri/)
 * (@samerhouri)
 * [2 years, 9 months ago](https://wordpress.org/support/topic/database-updating/#post-17038165)
 * Thanks (@t-p), In the beginning I followed that guide but as I told you , I,ve
   had so many wordpress errors , so I had to make a new installation.
 *  Moderator [threadi](https://wordpress.org/support/users/threadi/)
 * (@threadi)
 * [2 years, 9 months ago](https://wordpress.org/support/topic/database-updating/#post-17039159)
 * The error messages indicate that the named database tables do not exist in the
   database. How did you create the database dump and have you already imported 
   it into the target database?
 *  Thread Starter [samerhouri](https://wordpress.org/support/users/samerhouri/)
 * (@samerhouri)
 * [2 years, 9 months ago](https://wordpress.org/support/topic/database-updating/#post-17039304)
 * Thank you guys , I have deleted the old installation and installed a new one ,
   I had no other choice now it’s good.
 *  [duckhai](https://wordpress.org/support/users/duckhai/)
 * (@duckhai)
 * [2 years, 9 months ago](https://wordpress.org/support/topic/database-updating/#post-17040296)
 * I don’t know exact the case you done.
 * (Important: export your database before any thing)
 * Case1: Just change hosting, domain is not:
 * Check your table_prefix in the database and wp-config.php is the same.
 * + visit PHPMYADMIN to know what current table_prefix database
 * + in the wp-config.php, Looking for $table_prefix = ‘YOUR_TABLE_PREFIX’;
 * check it if the same in database.
 * Case 2: Change both hosting and domain:
 * as i see your curent site, you should you search and replace plugin (free version
   in WorPress.org is enough), then replace your old domain whit new one.
 * Example:
 * Old domain: [https://yourolddpmain.com/](https://yourolddpmain.com/)
 * Repalce whit: [https://yournewdomain.com/](https://yournewdomain.com/)

Viewing 7 replies - 1 through 7 (of 7 total)

The topic ‘database updating’ is closed to new replies.

## Tags

 * [database](https://wordpress.org/support/topic-tag/database/)
 * [migrate](https://wordpress.org/support/topic-tag/migrate/)
 * [wp-config.php](https://wordpress.org/support/topic-tag/wp-config-php/)

 * In: [Fixing WordPress](https://wordpress.org/support/forum/how-to-and-troubleshooting/)
 * 7 replies
 * 4 participants
 * Last reply from: [duckhai](https://wordpress.org/support/users/duckhai/)
 * Last activity: [2 years, 9 months ago](https://wordpress.org/support/topic/database-updating/#post-17040296)
 * Status: not resolved

## Topics

### Topics with no replies

### Non-support topics

### Resolved topics

### Unresolved topics

### All topics