advanced search

We Recommend

Version Control with Subversion Version Control with Subversion
Written by members of the Subversion open source development team, Version Control with Subversion introduces the powerful new versioning tool designed to be the successor to the Concurrent Version System or CVS. CVS users will find the "look and feel" Subversion comfortably familiar, but under the surface it's far more flexible, robust, and usable, and more importantly, it improves on CVS's more notable flaws.

Posted By

jarnaldich on 02/24/08


Tagged

mysql mysqldump


Versions (?)


Who likes this?

1 person has marked this snippet as a favorite

basicmagic


backup mysql databases

Published in: Other 

MySQL backup and restore example through mysqldump / mysql command line utilities.


Plain TextExpand 
  1. # Backup:

  2. mysqldump -u<usr> -p<pwd> <db> | gzip > <file>

  3.  
  4. # Restore:

  5. gunzip <file> | mysql -u<usr> -p<pwd> <db>

Report this snippet 

You need to login to post a comment.