• Moved a site from managed hosting (where I set up the site to test it) to Godaddy (where my client wants it to be hosted). The site on my client’s server (godaddy) is not showing up correctly, and I have concluded it’s a database issue.

    The test site works perfectly: https://www.bobbyg.flywheelsites.com
    The new hosting server is not finding all the wp components: https://www.bobbygsdiscjockeys.com/wp

    I took these steps to move the site:

    1. Downloaded database backup from managed hosting server.
    2. Requested and received wp-content directory from managed host.
    3. Set up new database on godaddy.
    4. Installed wordpress on godaddy.
    5. Replaced wp-content directory via ftp on godaddy.
    6. Imported database from previous hosting server.

    I am a designer and therefore not savvy with database query, but after researching, I found and ran the query below on the imported database on Godaddy via php My Admin to update domain, but it did not make any changes. I am not sure why. I managed to change the site and home url in the wp_options table manually, but there are still many tables that need to be updated and I know this can be done with a query. After many hours of trying to figure out the problem, I’m asking for help.

    Query used:

    UPDATE wp_v3sosqvqqd_options SET option_value = replace(option_value, 'https://www.bobbyg.flywheelsites', 'https://www.bobbygsdiscjockeys') WHERE option_name = 'home' OR option_name = 'siteurl';
    
    UPDATE wp_v3sosqvqqd_posts SET guid = replace(guid, 'https://www.bobbyg.flywheelsites','https://www.bobbygsdiscjockeys');
    
    UPDATE wp_v3sosqvqqd_posts SET post_content = replace(post_content, 'https://www.bobbyg.flywheelsites', 'https://www.bobbygsdiscjockeys');
    
    UPDATE wp_v3sosqvqqd_postmeta SET meta_value = replace(meta_value,'https://www.bobbyg.flywheelsites','https://www.bobbygsdiscjockeys');

    What am I doing wrong? I so appreciate any help on this.

Viewing 1 replies (of 1 total)
Viewing 1 replies (of 1 total)
  • The topic ‘Database trouble after migrating from managed hosting’ is closed to new replies.