Database trouble after migrating from managed hosting
-
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/wpI took these steps to move the site:
- Downloaded database backup from managed hosting server.
- Requested and received wp-content directory from managed host.
- Set up new database on godaddy.
- Installed wordpress on godaddy.
- Replaced wp-content directory via ftp on godaddy.
- 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.
- The topic ‘Database trouble after migrating from managed hosting’ is closed to new replies.