Transfer MySQL database (Easy)
Here's a method of backup-restore MySQL databases without using PHPMyAdmin which i have found a lirttle tricky, especially for large databases.
1. Download and install the free version of SQLYog (Trial) Here or Publisher's Site.
2. Add the access details for both your old and new MySQL databases. (Back-up your existing database - you can use SQLYog by clicking 'Backup Database as SQL Dump').
3. Connect to the two databases at the same time and open the window sith the data you want to transfer.
4. If both databases are successfully open - the 'Copy Database to different Host/Database' icon will be available. Select the correct tables/all and it's as easy as that.
Last Updated (Saturday, 24 October 2009 15:22)


