I’d like to backup all of our databases in one large mysqldump file. Our databases are approaching 10GB in size so this is probably a few hours of processing. I’d like to run this against a slave which is a read only.
What would be the best steps to do this? For example:
Restart database in read only mode
Run mysqldump command, what are the exact / best parameters to backup everything? all databases, users, permissions, etc?
After the backup is done, I’ll restart the database in normal mode and restart the slave and let it catch up.
After I have the backup file, I’d like to test a restore against an empty database, what would be the mysqldump command?
Is there a faster / better way?