One-line shortcut to dump to a compressed file:
mysqldump --opt -u[name] -p my_db | gzip -9 > my_db.sql.gz
Dump with stored procedures
mysqldump -u[name] -p --routines [--no-data] [database] | sed -e "s/;;/\$\$/g" > procedures.sql
One-line shortcut to dump to a compressed file:
mysqldump --opt -u[name] -p my_db | gzip -9 > my_db.sql.gz
Dump with stored procedures
mysqldump -u[name] -p --routines [--no-data] [database] | sed -e "s/;;/\$\$/g" > procedures.sql
