mysql database backup

backup mysql databases

for all databases owned by $user

mysqldump -u $user -p --all-databases > backup.sql

for a single database owned by $user

mysqldump -u $user -p $database > backup.sql

to restore all databases

mysql -u $user -p < backup.sql

to restore a specific database

mysql -u $user -p $database < backup.sql

Leave a Reply

Your email address will not be published. Required fields are marked *

To create code blocks or other preformatted text, indent by four spaces:

    This will be displayed in a monospaced font. The first four 
    spaces will be stripped off, but all other whitespace
    will be preserved.
    Markdown is turned off in code blocks:
     [This is not a link](

To create not a block, but an inline code span, use backticks:

Here is some inline `code`.

For more help see

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>