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

dra$tic · Dec 2, 2011

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.

l0goz · Dec 2, 2011

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.

hackedd · Dec 2, 2011

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

dra$tic · Dec 2, 2011

l0goz said:
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.

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'

hackedd said:
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

I'll give it a shot..

dra$tic · Dec 2, 2011

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"

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

dra$tic

BANNED

l0goz

Power Member

hackedd

Junior Member

dra$tic

BANNED

dra$tic

BANNED

Main Menu

Marketplace

Making Money

BlackHatWorld

Other