8/4/2006
Quick and Dirty MySQL Backup
This is great for a quick backup of all databases before performing maintenance or check/repair.
mysqldump –all-databases -p | gzip > db_dump-YYYYMMDD.gz
Replace YYYYMMDD with Year, Month and Day.
Related Link: payday loans cash advance needs
Popularity: 19%
December 8th, 2006 at 7:52 pm
“Replace YYYYMMDD with Year, Month and Day.”
No need!
mysqldump –all-databases -p | gzip > db_dump-`date %Y%m%d`.gz
March 13th, 2007 at 3:23 pm
[…] previously posted a Quick and Dirty MySQL Backup snippet. It works well in a pinch, but it doesn’t have any features. I use it primarily as a […]