Although not always the most efficient, mysqldump is a handy way to migrate your MySQL server — particularly if you don’t have many schemas and the size of data is small.
To create backup, first list all schemas on the server using
I normally avoid backing up performance_schema, information_schema and mysql schema. They contain database configuration, user settings etc. This would mean you have to reconfigure all your settings on the new server
Then take the dump of all schema using this command:
mysqldump -u***** -p***** --databases <space_separated_schema_names> > mybackup_20131107_1223.sql
Then compress, transfer and inflate the sql file into the new server’s host. When you’re ready to restore, just do
mysql -u***** -p***** < mybackup_20131107_1223.sql