How to move my Wordpress blog to another host
When you have a host on your own domain which uses wordpress and you want to change hosts there are a few steps you need to take:
1. FTP to your current host and download all the files and folders associated with your domain.
2. Export your database - login to your host phpMyAdmin, click on the database you need to export (on the left panel of phpMyAdmin), on the right top click Export (see image below).

On the next screen make sure that all the table fields are selected and that the following options are checked:
Add DROP TABLE / DROP VIEW
Add IF NOT EXISTS
Add AUTO_INCREMENT value
Enclose table and field names with backquotes (see image below)

Check the Save as file options and click the Go button.

Save the .sql file to your hard drive.
3. Login to your domain registrar and change the domain DNS to your new hosts DNS servers. Wait for the domain to propagate (it could take from 5 minutes to 72 hours).
4. Create a new database on your NEW host - use the host control panel.
5. Import the database using the sql file you exported in step 2 - login to the new host phpMyAdmin, click on the database you just created (on the left panel of phpMyAdmin), on the right top click Import.

Navigate to the .sql file on your hard drive and click Open.
If your database is too big and can not be imported via phpMyAdmin please read How to import large databases.
6. Open the wp-config.php file and change the name, the username, and the password to the new database’s name, username, and password (in most cases the MySQL host name is localhost but in rare occasions you might need to change that too, ask your new host if unsure).
7. FTP to your new host and upload all the files you downloaded in step one.
8. Open your web site in your browser - your blog looks just the way it did before the move!






