It’s handy, fast, and convienient to you mysql on the command line.
Lately, what I’ve been using it most for is to back up and restore
databases. I don’t do it often enough to have the commands committed to
memory, but everytime I need it I go searching for it again. Rather
than trying to find my previous search results again I’ll post them here
with a summary.

To back a mysql database into a gzipped archive:

mysqldump [database] | gzip > backup.sql.gz

To restore the backup:

gunzip < backup.sql.gz | mysql [database]

Reference: web cheat sheet

This entry was posted on Tuesday, April 8th, 2008 at 00:00:00 and is filed under Technology. You can follow any responses to this entry through the RSS 2.0 feed. You can leave a response, or trackback from your own site.