[resolved] Mysql database: tranfer from one server to another (5 posts)

  1. gstokes123
    Posted 2 years ago #

    Hi all,
    I'm new to CMS websites, been doing static sites for years. I want to move my recipe website from (http://jge.dev4.webenabled.net/) to Goddaddy's server (http://cooksinternational.com). I downloaded the wp-content file and uploaded to the new site location. That worked fine (after a little learning curve). Then I downloaded the WordPress database and uploaded the database to the new site location using myphpadmin. All of my work was at the new site, and I started to make some changes (widgets, plug-ins, etc.) and after a while I noticed that the site URL reverted back to the (http://jge.dev4.webenabled.net/) location. In the Mysqladmin data view of my database I notice many references to the (http://jge.dev4.webenabled.net/) location. So now both sites are screwed up since I inadvertently made changes to the first site. I am looking for a straight forward solution to be able to move a WordPress website, and Mysql database to another hosting server so I don't have to start the website all over again from scratch. I have a clean copy of both (wordpress website and database)on my home computer.

  2. michael.mariart
    Posted 2 years ago #

    This is a "standard" problem when changing domains. You can change the domain in the settings area, but every hard-coded link in your posts/pages/etc will always point back to whatever URL you had at the start.

    I've found this tool that makes the change easy. I use it on every site that I do. it's quick, and works well, so try it out.

  3. Swati
    Posted 2 years ago #

    Before moving your site first deactivate all plugins and after moving reactivate them one by one.

  4. esmi
    Forum Moderator
    Posted 2 years ago #

  5. gstokes123
    Posted 2 years ago #

    Thanks for all the support. i started by
    1. Deactivating all of the plug-ins at old site.
    Than after a variety of approaches towards transferring my website to a different outside server,

    2. I used myPHPadmin to export/import just the wp-(comments, links, options, postmeta, post terms, term_relationships & taxonomy, usermeta, and user) tables from my old WordPress database.

    3.I than used the search and replace tool mention above (PHP Search|Replace Tool) on each of the tables.

    4. Activated my plug-ins on the new site location; I am good to go!

    Thanks again for all your support!!!!!

Topic Closed

This topic has been closed to new replies.

About this Topic