Creating a backup of your MySQL database

mysqlOne way to capture a backup of your database is to 'dump' it into an SQL file. This article describes the process.


mysqldump

Run the following command to create a backup of your database.

$ mysqldump -u steven -p mydatabase | gzip > mycompressedfile.sql.gz

Note that you do not need to run mysql first. This command can be run straight from the command line.

 

Thanks for visiting.