Monthly Archives: January 2011

extract and reload mysql database — GZIP on the fly.

To dump a mysql database use the mysqldump command and pipe it to gzip on the fly so the resulting backup file is compressed with this command: mysqldump -u[uname] -p [dbname] | gzip – > backupfilename.dmp.gz To restore this on … Continue reading

Posted in Uncategorized | Leave a comment