backup mysql

[quimfv]

http://blog.tatedavies.com/2011/01/1...use-mysqldump/

Compressed backups

More often than not, a database dump will be several hundred MB in size, if not more. MySQL can zip this for you automatically using the gzip command:

mysqldump -u root -pABC123 customers | gzip > compressed-backup.sql.gz

The pipe before the gzip tells mysqldump to send the output to the next command, which is gzip and that, in turn, is asked to create “compressed-backup.sql.gz”

http://gnuwin32.sourceforge.net/packages/gzip.htm