Linux tip, Fedora tip / howto: Making a backup of all MySQL databases
Making a backup of all MySQL databasesThis is more of a short "note to self":
mysqldump --all-databases --force -u root -p
(--force makes it continue even when there are errors, try it without this option first)
If you also want all stored procedures in there, add the --routines option.
If you want just the structure (CREATE TABLE etc.), add the --no-data option.
To put the result in a file, append:
To compress the result by a factor of 8-10: