Backup utility for database, folders and files
Backs up a MySQL database, folders and files to a default folder (~/backup) or to a specified folder. If the –cron switch is provided the specified database and files are not backed up rather a cron job of the provided command is added to crontab.
Install
The application can be installed with
$ gem install syc-backup
Usage
Backup a database to the default folder _~/backup_
$ sycup -d database -uuser -ppass
Backup a MySQL database, a directory and files to the default folder
$ sycup -d database -uuser -ppass -f directory,file1,file2
Specify a backup folder
$ sycup backup/folder -d database -uuser -ppass -f directory,file1,file2
Override files in the backup folder if they exist
$ sycup backup/folder --override -f directory,file1,file2
Don’t compress the backup
$ sycup --no-compress -f directory,file1,file2
Create a cron job that is scheduled every day at 2:30
$ sycup -d database -uuser -ppass -f directory,file1 --cron 30,2,*,*,*
Supported Platform
syc-backup has been tested with 1.9.3
Notes
The application backs up the MySQL database with mysqldump. The dumpfile has the form yyyymmdd-HHMMSS_databasename.sql. After the files are backed up the dumpfile will be deleted.
If the –no-compress is provided the files are copied to the backup folder. Otherwise they are compressed with _tar cfz YYYYmmdd-HHMMSS_syc-backup.tar.gz_.
If the –override switch is not provided the backup directory will be added a timestamp. So if you create a cron job you should every now and then delete obsolete backup folders.
The source contains lib/backup/file_backup.rb which is not used in the application.
Tests
The tests create folders and files and will be deleted after the tests finish. MySQLBackup needs to run a MySQL database with a database test and a user user with the password pass.
The test files live in the test folder and begin with test_.
Links
- www.github.com/sugaryourcoffee/syc-backup
-
Source code on GitHub
-
- syc.dyndns.org/drupal/content/backup-drupal-database
-
Development notebook
-
- rubygems.org/gems/syc-backup
-
RubyGems
-