Creating a quick dump for your mysql database
Doing dumps is a common task but I always forget exact code to do that, and looking for exact page manual is dull. Here goes the generic code:
Mysql Pre-4.1
4.1 and up
Great for doing maintenance backups via cron, or just occasional dumps for off-site storage and archival.
And useful shorthand for the manual:
http://dev.mysql.com/doc/mysql/en/mysqldump.html
Mysql Pre-4.1
mysqldump -u username -p password --quick [database [table1, table2, ...]] > backup_db.sql
4.1 and up
mysqldump -u username -p password [database [table1, table2, ...]] > backup_db.sql
Great for doing maintenance backups via cron, or just occasional dumps for off-site storage and archival.
And useful shorthand for the manual:
http://dev.mysql.com/doc/mysql/en/mysqldump.html