Ever wondered how to transfer one WordPress site database to another domain? Here’s how step by step. Let’s say you have a site at domainone.com and you want to move it to domaintwo.com/yoursite and you have cPanel.
- go to domainTwo.com/cpanel and install wordpress in a new folder or directory called ‘yoursite’ (using fantastico’ from your cpanel)
- Now go to domainOne.com/wp-admin and click on ‘Tools’, then click on export to export the whole site to your desktop
- Now go to domainTWO.com/YOURSITE/wp-admin and click on Tools, then click on import to inport your site to this new location. THAT’s it!
You can now see the new database for your site when you go to domainTWO.com/cpanel and click on ‘phpmyAdmin’. The new database should be located on your left hand. Click on it to see all the tables that have been created. Your posts/pages should be located in a table named something like wp_………posts