Dump DB and zip mysqldump -u root -p --single-transaction --quick --extended-insert --all-databases | /usr/bin/bzip2 --fast > ./MySQL.bak.bz Using LVM Snapshots MySQL Performance Blog Restore a DB from file mysql -uusername -p < backup.sql