Transferring WP Site to New Host- EXTREMELY DIFFICULT

8 replies
  • WEB DESIGN
  • |
So I've seen plenty of guides out there on the web about transferring a Wordpress site to a new host but NONE of them offer a complete explanation. I am planning on making a real guide that actually fills in all the gaps once I get this all figured out. I am trying to transfer my site http://colonirritable.net to HostGator from SEOHost. Right now the site just says "Error establishing a database connection".

Here is what I have done:

1. Made addon domain "colonirritable.net" in HostGator, installed Wordpress 3.5.

2. Replaced entire "wp-content" directory with my old "wp-content" directory from SEOHost.

THE KEY PLACES WHERE I PROBABLY MADE A MISTAKE:

3. In "PHP MyAdmin"- selected Databases> Selected the new Hostgator Database> Selected "Import"> Imported old database from SEOHost(after editing username to match the current one)

Now the database is "there" in PHP MyAdmin but it is not being connected to.

I also replaced the wp-config.php file and changed the DB_USER to the database I want- but the password I left the same as the database in SEOHost because I don't know if it has changed when I imported it or what.

Does anyone have experience with this?
#difficult #extremely #host #site #transferring
  • Profile picture of the author Michael71
    Signature

    HTML/CSS/jQuery/ZURB Foundation/Twitter Bootstrap/Wordpress/Frontend Performance Optimizing
    ---
    Need HTML/CSS help? Skype: microcosmic - Test Your Responsive Design - InternetCookies.eu

    {{ DiscussionBoard.errors[7784935].message }}
  • Profile picture of the author Patrick
    Originally Posted by bathunter View Post

    Right now the site just says "Error establishing a database connection".
    Means the database info you have saved in wp-config.php is incorrect. Verify it and update it.
    {{ DiscussionBoard.errors[7785291].message }}
    • Profile picture of the author webss
      Originally Posted by schwarzes View Post

      Means the database info you have saved in wp-config.php is incorrect. Verify it and update it.
      This sounds like what needs correction. You usually have to change in the wp-config the username, password and host info. You should be all set after that.
      Heres some info.
      Editing wp-config.php « WordPress Codex
      {{ DiscussionBoard.errors[7785329].message }}
  • Profile picture of the author Cleaner44
    I have moved a few using this Plugin:
    http://wordpress.org/extend/plugins/...by-wp-academy/

    It was easy and worked well for me. I have no idea what the downside would be.
    {{ DiscussionBoard.errors[7791560].message }}
  • Profile picture of the author naoshad
    I also replaced the wp-config.php file and changed the DB_USER to the database I want- but the password I left the same as the database in SEOHost because I don't know if it has changed when I imported it or what.
    Why did you do this? Since you imported all the data from your previous host(SEOHost).

    First of all double check your wp-config.php file:

    /** The name of the database for WordPress */
    define('DB_NAME', 'your-database-name');

    /** MySQL database username */
    define('DB_USER', 'your-database-username');

    /** MySQL database password */
    define('DB_PASSWORD', 'your-database-pass');

    /** MySQL hostname */
    define('DB_HOST', 'localhost');

    For help you can check this: http://www.hostgator.com/tutorials/c...l-database.htm

    Secondly: make sure that you drop all the tables of your hostgator hosting wordpress database and imported your previous hosts database dump.

    I hope this will work.
    Signature
    Web Application Developer, Wordpress Plugin/theme expert. Contact me for any Website maintenance , Custom Web Application Development project.
    {{ DiscussionBoard.errors[7791692].message }}
  • Profile picture of the author Deezign
    Hi there,

    I have transferred tons of Wordpress sites (because I am flipping them). If you need help, just send me a message with your Skype and I can transfer it for you.
    {{ DiscussionBoard.errors[7792119].message }}
  • Profile picture of the author MarvyDery
    It would be easier for you if you buy the wordpress plugin called backup buddy. it will automate the whole process and make things easier for you
    {{ DiscussionBoard.errors[7792647].message }}
  • Profile picture of the author AdrianDanut
    I've been using a plugin called Duplicator for a long time now and it works really great. Here is the link: WordPress › Duplicator « WordPress Plugins

    Basically it initially creates an installer.php file and an archive containing everything (pages, posts, plugins, themes, databases, users etc.). After copying those two files to the new website location it does everything in a few steps. All you have to do is create the db and user in your cpanel.
    Signature


    GUARANTEED amazon kindle rankings in 6 weeks or less.
    Grab my FREE Kindle Word Formatting Template
    Adrian Kindle Danut
    fastkindlecash.com
    {{ DiscussionBoard.errors[7793054].message }}

Trending Topics