From one host to another – Please help!

  • Hi Folks,

    I really hope someone can help. I had a site on my personal host. I have a lot of customizations, etc. I needed to move it to the live host. I followed these instructions:
    https://wp.smashingmagazine.com/2013/04/08/moving-wordpress-website/

    They seemed pretty straight forward. I installed WP on the new host, updated it to the most current version as that’s what I had on my personal host. Move over the content folder, dropped the DB tables and tried to import the save db. But everytime I do it I get a “There is a chance that you may have found a bug in the SQL parser. I can’t import it.

    To make matters worse, I used the Search-Replace-DB process I read on that tutorial site and somehow messed up all the urls in my initial site… so now I can’t get either site to work.

    Can anyone help? I’m willing to hire someone on an hourly bases if that’s what it takes. I gotta get this going…. Thank you.

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

  • This is how I handle moving a site from a “test” environment to a “live” environment:

    1. Log in to the “test” WP site and change both the WordPress Address (URL) and Site Address (URL) to the “live” address.
    2. Log in to the control panel on the “test” site and export the database using phpMyAdmin.
    3. Upload a fresh install on the “live” server.
    4. Log into the “live” server and import the database dump using phpMyAdmin.
    5. Modify the wp-config.php file with any database information changes.
    6. Test the site in a browser to ensure the site is coming up.
    7. Log into the live WP site using the login credentials setup on the “test” server.

    Hope this helps.

    Thread Starter jburnard

    (@jburnard)

    Thank you for the quick reply! I have checked the wp-config file and it appears to be correct. At least it’s pointing to the new database, etc.

    I’ve somehow screwed up my test site. All my urls are pointing to the new location so I can’t even get into the admin section. I’ll type:

    https://www.burnardweb.com/caa/wp-admin (test site)
    but it tries to go to:
    https://www.childrenacrossamerica.org which is the new site….

    Any thoughts? Thanks again!

    The wp-admin for the new site is showing the old site and sets it to redirect to the new site. Seems you may have changed both the WordPress Address and Site Address prior to moving the database. You will need to go into the Database and check for the old address.

    It will be in the wp_options table (or whatever your prefix). Search for the old site by entering it in option_value using the %LIKE% option. It will most likely be found for the siteurl.

    Thread Starter jburnard

    (@jburnard)

    Wow, you have saved my bacon! I was at least able to get the old site to show up again and almost view correctly. I have a few missing images etc but I can at least fix those. I guess my best plan is to get the old site up to speed again and then try the migration following your suggestions.

    One question though… why do you suppose my import of the database kept throwing errors? I simply exported the database from the test site using phpmyadmin and then dropped the files in the new database and them imported from the backup. Am I doing something wrong? Thank you again!!!

    If you simply imported the database from a phpmyadmin backup, I’m not sure what caused the issues, aside from the siteurl not pointing to the right address. As for the images, these are most likely pointing to the old site and can be found (I believe) using the same method as above for the siteurl.

Viewing 5 replies - 1 through 5 (of 5 total)
  • The topic ‘From one host to another – Please help!’ is closed to new replies.