Make a clean snapshot of a drupal website, files and databases

athoune's picture

The classical mysqldump is not enough to backup a drupal website.

With Snapshot, you can freeze your website and make a clean snapshot, mysql data and files. Different backup type can be done, simple copy, rsync and even rdiff-backup wich provide differential backup.

For now, only myIsam tables can be backuped. I follow percona work to handle innodb soon. Postgres must not be hard to handle.

For now, backup is local. Soon, distant copy will be handled with rsync, ftp and even S3.

Beta version is on github : http://github.com/athoune/Drupal-Snapshot/tree/master
And official release are on Drupal : http://drupal.org/project/snapshot

Groups:
Login to post comments

good module

likewhoa's picture
likewhoa - Sun, 2009-05-24 15:54

question, is the module using mysqldump --lock-tables? eitherways, looks interesting and something to offer clients. I just use a custom bash script that backs up and restores.


without Mysqldump!

athoune's picture
athoune - Sun, 2009-05-24 19:48

This module doesn't use mysqldump. Mysqldump is a nice tool to migrate data, but it's to slow for a daily backup. Like explain in the nice book "High performanceMysql", I'd rather directly copy mysql files, inside a lock. So, tables are locked.

I use a custom bash script too, to rsync backuped data from the server to my computer. Distant backup is essential.


ahh so you basically locking

likewhoa's picture
likewhoa - Mon, 2009-05-25 14:51

ahh so you basically locking all tables and copying the whole /var/lib/mysql folder?