How to backup and restore a mysql database

Posted: 03/29/2009

To dump your database:

  mysqldump -u USER -p PASS my_db > my_db.sql



Then to restore:




  mysql -u USER -p PASS my_db < my_db.sql





Or, using gzip for compression, dump with:




  mysqldump -u USER -p PASS my_db | gzip > my_db.sql.gz





And restore with:




  gzip -cd my_db.sql.gz | mysql -u USER -p PASS my_db






        
     


     

        
About Me

        
I'm a skier, web developer, entrepreneur, freelancer, and all around stand-up guy living in Manhattan. This is me, repping one of my favorite shirts...

        
        

        Follow me on twitter or send me an email. 

        
All Posts