Backup database and other attachments in ROR

07/Sep/2013 · 2 minute read
  1. rsync:http://rsync.samba.org/
  2. Crontab:http://unixhelp.ed.ac.uk/CGI/man-cgi?crontab+5
  3. “Linux Crontab 定时任务 命令详解”:http://blog.csdn.net/tianlesoftware/article/details/5315039
  4. [rubygem]“backup”:https://github.com/meskyanichi/backup
  5. [rubygem]“whenever”:https://github.com/javan/whenever

Automatically backup on the remote server:

Let’s firstly assumpt:

  1. You have a site named “example.com”;
  2. You can login to it through a username “deploy”, and its password is “password”;
  3. You located the contents of your site in /var/www/example/;
  4. Your database server is Mysql, and the database for your site is example_production.

1. SSH login:

2. Install the backup:

3. Prepare directories for backup files:

4. Generate and edit backup script:

Input the below content:

# encoding: utf-8

Backup::Model.new(:example_db, 'Dumping example Production Database') do
  split_into_chunks_of 250

  database MySQL do |db|
    db.name               = "example_production"
    db.username           = ""                      # Replace the blank string with your real username
    db.password           = ""                      # Replace the blank string with your real password
    db.host               = "localhost"
    db.port               = 3306
    db.socket             = "/var/run/mysqld/mysqld.sock"
    db.additional_options = ["--quick", "--single-transaction"]
  end

  store_with Local do |local|
    local.path       = "/var/www/example/backup/db"
    local.keep       = 10
  end

  compress_with Gzip
end

Run backup command to confirm that your config works:

Attention: Remember to update the config file if you have changed the username and/or password of the database.

5. Install whenever:

6. Generate a schedule.rb file with whenever:

The last command will create a new file named “schedule.rb” under config/ directory.

7. Add a daily task:

Open the file to edit:

Contents:

set :output, "~/Backup/example_whenever.log"           # This is important, it can help you to find the reason when failed to backup the database
every :day do
  command "cd ~/Backup && backup perform -t example_db"
end

8. Update whenever task into crontab:

9. Check whether the task is updated successfully or not:

If successed, you should see your new task shown at the bottom of the file.

Synchronize remote backups every day automatically by rsync and crontab:

Attention: Below operations are played on a different server, which is used to sync files. We assumpt its domain is another.com and the username is deploy.

1. SSH login:

2. Write a synchronize shell script:

Input the below contents into the new file named ‘sync.sh’:

and then, assign the scripe execution authority:

Run the script to ensure everything works well:

Attention: Because it is required to be authorized to access the targer server, you should remember to copy your ssh public key to the target server(such as, example.com) before you can sync files.

3. Open user’s crontab config file:

Append the below task at the end:

Ok, that’s all. The rest work is that remember to check if there is any backups generated.

版权声明：本文为原创文章，转载请注明来源：《Backup database and other attachments in ROR - Hackerpie》，谢绝未经允许的转载。