db_backup.rake 436 B

12345678910111213141516
  1. namespace :db do
  2. desc "Backup the production database"
  3. task :backup => :environment do
  4. backup_dir = ENV['DIR'] || File.join(Rails.root, 'db', 'backup')
  5. source = File.join(Rails.root, 'db', "production.db")
  6. dest = File.join(backup_dir, "production.backup")
  7. makedirs backup_dir, :verbose => true
  8. require 'shellwords'
  9. sh "sqlite3 #{Shellwords.escape source} .dump > #{Shellwords.escape dest}"
  10. end
  11. end