Backup MySQL
From GWAVA Technologies Training
This article is a very bare bones "dummy's guide" set of information. If you'd like to learn more check out the MySQL page on using MySQL dump: http://dev.mysql.com/doc/refman/5.5/en/mysqldump.html Or this article on database backup methods if you'd like to look into other options. Plus there's a whole world of internet to search.
MySQL dump
The mysqldump program bundled with MySQL is one of the best ways that has been found to backup a MySQL database.
For Retain you'll want to use the --single-transaction switch Check out the MySQL documentation here
Now for the examples
Linux
At the command line type mysqldump