Linux tip, Fedora tip / howto: Making a backup of all MySQL databases |
Try my online puzzle page with Calcudoku, Killer Sudoku and online Sudoku.
Making a backup of all MySQL databases This 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:
|
Send me your comments!
Something didn't work as expected? You'd like to add some useful info to this tip? Use the form below to send me your comments. (Don't forget to fill out the super-lame CAPTCHA below..)