Move WordPress Database

Move WordPress Database

My WordPress database was initially installed in a shared database with four other WordPress installations.  I wanted to move my blog to its own database so that it would be easier to backup and restore.

To Move WordPress Database, you need to place your WordPress into maintenance mode so  no changes are made while doing this.

In phpMyAdmin I selected the database, went to the export tab.  Then I selected the tables that contained my WordPress installation, then export it to SQL  format.  I saved the exported database to my local hard drive. After the export, I opened the exported file with Notepad++ I edited the database name and any paths, and save it as a new file. (Note – always keep plenty of backups.)

After editing the file and verifying the changes. then open phpMyAdmin and create a new empty database. After creating the empty database, select the database and go to the import tab. Select the edited file and complete the import.

In your WordPress installation rename the wp-config.php, then open your blog. The installation page will appear, complete the database connection information and save, this is all that is required to connect to the new database. Login as admin and turn off maintenance mode. Your blog should be up and running in the same state it was in before the migration, (except in it”s own database). If it does not work go back and check everything and repeat the steps.

This should be able to be done in about thirty minutes.

After you have tested your installation and everything is working you can delete the old instance in the shared database.   This is basically the same steps that you would use to move your WordPress to  a new server.

Good luck 🙂

Links

Myphpadmin Home Page

Mysql Home Page