This may not be of use or interest to anyone else, but at least I’ll remember where I stored this command for my own future use.
mysqldump -u root -p --events --ignore-table=mysql.event --all-databases > all_databases07.sql
So what does it do:
mysqldump -u root -p
Calls the mysqldump program using user root and prompting for root’s password.
In version 5.1.6, scheduled events were added which therefore leads to a warning message if we don’t exclude the events table.
Does what it says on the tin, backup up all the databases. You could instead backup a single or group of databases using
db_name1 db_name2 db_name3
The filename to store it all in. I manually change a sequential number but any filename will do.
Full on-line reference manual for MySQLdump is here.