Backup and restore of MySQL should be done using the utilities that come packaged with MySQL. This section briefly describes the process.
Backup should be taken using the mysqldump utility. Following is the syntax of command.
Backup taken using mysqldump is an SQL dump. You can restore the database using any MySQL client. Following is the command syntax for the CLI mysql client.