Class: Railscluster::MysqlDatabase

Inherits:
Database
  • Object
show all
Defined in:
lib/railscluster/capistrano/backup.rb

Instance Attribute Summary

Attributes inherited from Database

#config

Instance Method Summary collapse

Methods inherited from Database

build, #initialize

Constructor Details

This class inherits a constructor from Railscluster::Database

Instance Method Details

#backup_command(local_port, application) ⇒ Object 



53
54
55
56
57
 
# File 'lib/railscluster/capistrano/backup.rb', line 53

def backup_command local_port, application
  filename = "#{application}.mysqldump.#{Time.now.to_i}.sql"

  "mysqldump --user=#{config['username']} --password=#{config['password']} --host=localhost --port=#{local_port} --protocol=TCP #{config['database']} > backups/#{filename}"
end

#find_local_backup ⇒ Object 



59
60
61
 
# File 'lib/railscluster/capistrano/backup.rb', line 59

def find_local_backup
  `ls -tr backups/*mysqldump* | tail -n 1`.chomp
end

#restore_command(file) ⇒ Object 



63
64
65
 
# File 'lib/railscluster/capistrano/backup.rb', line 63

def restore_command file
  "mysql --user=#{config['username']} --password=#{config['password']} #{config['database']} < #{file}"
end

#server_port ⇒ Object 



49
50
51
 
# File 'lib/railscluster/capistrano/backup.rb', line 49

def server_port
  config['port'] || 3306
end