1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.

Easiest way to move a WordPress site to new domain/hosting?

Discussion in 'Web Hosting' started by dra$tic, Dec 2, 2011.

  1. dra$tic

    dra$tic BANNED BANNED

    Joined:
    Dec 20, 2010
    Messages:
    393
    Likes Received:
    108
    I need to move a few WP sites to new hosting, I have created backup files with a plugin called "Backup and Move" and everything goes smoothly until I attempt to restore it to a new location..

    I get an error like this: Warning: mysql_connect() [function.mysql-connect]: Access denied for user '*****'@'localhost' (using password: YES) in /home/****/public_html/*****.com/restore.php on line 193
    Error !! Could not connect to databse: Access denied for user '****'@'localhost' (using password: YES)

    I have created new database and usernames for this but something is not working. If anyone knows of an easier way to move a WP site (database/theme/posts/etc) to new hosting please help me out.
     
  2. l0goz

    l0goz Jr. VIP Jr. VIP Premium Member

    Joined:
    Jun 25, 2010
    Messages:
    543
    Likes Received:
    353
    Occupation:
    IM
    Location:
    Close to your mom
    Did you change the Database name and password access?

    That might be the problem.

    But Let me tell you the easiest way for me.

    I zip the whole folder, download it to my computer. then upload it to the new server. Inside the server i extract everything.

    Now DB setup. as you did, I create a new database mysql on the new hosting.

    Then I go back to my old hosting and access myphpadmin, then export all the tables into a .sql format in the computer. then go back to my new hosting, access myphpadmin and import my database.

    Once everything is done, what is left to do is go to the website folder, open and edit "wp-configuration.php" and change the DB_name and DB_password to allow connection with the new DB.]

    Hope it helps.
     
    • Thanks Thanks x 2
  3. hackedd

    hackedd Junior Member

    Joined:
    Aug 11, 2010
    Messages:
    138
    Likes Received:
    172
    Gender:
    Male
    U can use the WPTwin plugin for this. It`s the easiest way I know.
    Let me know if I can help you...

    Regards
    Edd
     
    • Thanks Thanks x 1
  4. dra$tic

    dra$tic BANNED BANNED

    Joined:
    Dec 20, 2010
    Messages:
    393
    Likes Received:
    108
    Hmm, I tried this but after trying to import to new hosting I get another error :(

    Code:
    Error
    SQL query:
    
    --
    -- Database: `information_schema`
    --
    CREATE DATABASE  `information_schema` DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci;
    
    
    MySQL said: 
    
    #1044 - Access denied for user 'drastic'@'localhost' to database 'information_schema' 
    

    I'll give it a shot..
     
  5. dra$tic

    dra$tic BANNED BANNED

    Joined:
    Dec 20, 2010
    Messages:
    393
    Likes Received:
    108
    WPTwin worked like a charm, thanks Edd! :)

    If anyone else is trying to use it when it asks for e-mail validation just enter "TV"