1.mysqldump allows you to backup a single database and multiple databases as well. 2.Now, assume that you want to take backup of database named source. Backup Single Database: mysqldump source > destination.sql Backup Multiple Databases: mysqldump --databases source-one source-two source-three > destination3.sql 3.Restore MySQL Database mysqldump source < destination.sql source is the name of database you want to restore and destination.sql is the backup file to be restored.
Code at your best..!