Creating a backup of your MySQL database
One 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.