A quick way to perform a MySQL backup and restore it whenever necessary.

In this guide, we will be utilizing two commands to perform our MySQL Backup and Restore procedure: mysql and mysqldump.

This command is used to dump a database or a collection of database. It saves SQL statements to a .sql file that you may execute to restore your database should the need arise. Using this tool, it is possible to backup a single database, a specific table in your database, multiple databases, or all the databases stored in your server.

mysql is an SQL shell that is used to query or to manipulate your database records. You may pass options to the mysql binary to execute SQL command straight from your shell.


1. Backup

Single Database


Specific Table in a Database


Multiple Databases


All Databases


2. Restore

All/Full Databases


Single Database


Specific Table in a Database


Leave a Reply