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.
Popularity: 1%
Most Popular Posts
Quick and Dirty MySQL Backup
Previous post: Google Unit Conversions
Next post: Mod_Auth_MySQL and ErrorDocument with Apache
{ 1 comment… read it below or add one }
“Replace YYYYMMDD with Year, Month and Day.”
No need!
mysqldump –all-databases -p | gzip > db_dump-`date %Y%m%d`.gz
{ 1 trackback }