Easiest way to move a database
I’m currently moving to a new host, a vps in fact, and so I’ve been struggling with various ways to move my sites. The files aren’t that much trouble, but the databases have been causing me some trouble. So if you don’t want to mess with ssh/telnet and you have cpanel then this is the way for you.
1. Login to your old host cpanel.
2. Go to backups and download a backup of the database you want to move. It will be downloaded as a .gz which is greatly compressed. One of my databases was compressed by over 8 megabytes as compared to a .zip.
3. In your new host’s cpanel go to backups and upload the .gz file that you get and you should have a working database within minutes.
I hope you find this useful as I wish that someone had told me this before I spent so much time looking for a good way.
