Join GitHub today
GitHub is home to over 28 million developers working together to host and review code, manage projects, and build software together.Sign up
Rails plugin that provides Rake and Capistrano tasks for making database backups
Fetching latest commit…
Cannot retrieve the latest commit at this time.
|Failed to load latest commit information.|
= Awesome Backups This Rails plugin provides Rake and Capistrano tasks for making database backups. == Rake You can create new backups, specifying which tables to skip. This will create a +backups+ directory in your app root, and will create a directory with the current timestamp that has a copy of the current schema and fixtures with data for each of your current tables. $ rake db:backup:create SKIP_TABLES=sessions,audits You can restore your database to either the latest version, or a specific version. $ rake db:backup:restore VERSION=20080908120356 == Capistrano With Capistrano, you can create and download backups from your server using capistrano: $ cap backup:create $ cap backup:download Or, if you want to create a new backup of the server and mirror it to the local database: $ cap backup:mirror You can automagically create backups any time `cap deploy:migrations` is run. Just add a callback in config/deploy.rb: before 'deploy:migrate', 'backup:create' == ToDo * Database-specific backup strategies: it would be nice to have the option of using different stragegies for different databases. For example, use `mysqldump` for MySQL databases, or simply copy the database file for SQLite.