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 to see the link]

Viewing 7 replies - 1 through 7 (of 7 total)
  • Thread Starter samerhouri

    (@samerhouri)

    I forgot to mention that I am looking to retreive my old contents

    Moderator t-p

    (@t-p)

    while migrating my website to a new hosting

    WordPress has documentation on moving a site: 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 1 year, 6 months ago by t-p.
    Thread Starter samerhouri

    (@samerhouri)

    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 exist
    wp_hkhs_posts: Table ‘samerhouri_herbfits.wp_hkhs_posts’ doesn’t exist
    wp_hkhs_postmeta: Table ‘samerhouri_herbfits.wp_hkhs_postmeta’ doesn’t exist
    wp_hkhs_terms: Table ‘samerhouri_herbfits.wp_hkhs_terms’ doesn’t exist
    wp_hkhs_term_taxonomy: Table ‘samerhouri_herbfits.wp_hkhs_term_taxonomy’ doesn’t exist
    wp_hkhs_term_relationships: Table ‘samerhouri_herbfits.wp_hkhs_term_relationships’ doesn’t exist
    wp_hkhs_termmeta: Table ‘samerhouri_herbfits.wp_hkhs_termmeta’ doesn’t exist

    Thread Starter samerhouri

    (@samerhouri)

    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.

    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

    (@samerhouri)

    Thank you guys , I have deleted the old installation and installed a new one , I had no other choice now it’s good.

    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/

    Repalce whit: https://yournewdomain.com/

Viewing 7 replies - 1 through 7 (of 7 total)
  • The topic ‘database updating’ is closed to new replies.