If you need to move your worpress blog and the database to another web host or even to a new domain name it isn’t that complicated. If you don’t know how to back up wordpress read that first.
Moving wordpress to new host with same domain:
The first thing you will need to do is create a database. You should know how to do that, but if you need refreshing you can read how to do that here how to install databases.
First go into PHPmyadmin. Click on the database on the left column that you just created on your new site. Then on the top there will be a menu that has “STRUCTURE SQL SEARCH QUERY EXPORT IMPORT” . Click on IMPORT. Then click on the choose button to locate where your database .sql file is located on your hardrive. Click Go and wait for your file to upload.
If you have any issues during the upload because of very large files, etc then you should get help in a support forum. For newbie webmasters, the files should be small and not a problem importing.
Once PHPmyadmin is done, that means your database data has successfully been uploaded to your new host! The next thing you need to do is edit your config files for your wordpress for the new database name you created on your new host. Even though the database name probably will be a different name, all your old database information works because you simply just copied all the tables and data.
The final step will be to FTP your previous wordpress software files to your new account so you will have your old template.
Moving wordpress to new host with different domain:
If you want to move your wordpress database to another webhost, but with a different domain, first follow all the previous steps above.
Since you are moving to a different domain you will have to edit the actual database in order to do it. You cannot simply just change it inside the wordpress panel because the blog won’t work on the new domain without the database being edited.
Once you have done everything in the previous part above to get your wordpress database ready to go, it is now time to go edit the tables. Go in PHPmyadmin and click on the created database. On the menu at top (where export and import are located) click on “STRUCTURE” option. Then scroll down till yuo see WP_OPTIONS click on the browse icon to the right. Then you will see a bunch of tables. You will want to find SITEURL and click on the little pencil(edit) icon. Inside there you will just simply change the old domain name to the new domain name. Then click go and it will be saved. The next table to find is HOME. Edit that one just like SITEURL. You may have to go to the bottom and go to the next page to find this table.