Quick Backup of MySQL Database 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 Tagged on: Backup, Linux, MySQL, mysqldump By Alec | 01/05/2009 | Backup, MySQL, MySQL Administration, Webmaster | No Comments | ← Linux WebcamChange Fedora 9 Login Screen to KDM (GDM does not login) →Leave a Reply Cancel replyYour email address will not be published. Required fields are marked *Comment Name * Email * Website This site uses Akismet to reduce spam. Learn how your comment data is processed.