Class: Leipreachan::Backuper

Inherits:
DBBackup show all
Defined in:
lib/leipreachan/mysql2.rb,
lib/leipreachan/postgresql.rb

Constant Summary

Constants inherited from DBBackup

DBBackup::DIRECTORY, DBBackup::MAX_DAYS

Instance Attribute Summary

Attributes inherited from DBBackup

#backup_file, #backup_folder, #base_path, #db_config, #directory, #max_days, #target_date

Instance Method Summary collapse

Methods inherited from DBBackup

#backup!, #initialize, #list, #restore!, #restorelast!

Constructor Details

This class inherits a constructor from Leipreachan::DBBackup

Instance Method Details

#dbbackup!Object



3
4
5
6
# File 'lib/leipreachan/mysql2.rb', line 3

def dbbackup!
  password = db_config['password'].present? ? "-p#{db_config['password']} " : ""
  system("mysqldump -u#{db_config['username']} #{password}-i -c -q --single-transaction #{db_config['database']} | gzip > #{backup_file}.gz")
end

#dbrestore!(file) ⇒ Object



8
9
10
11
# File 'lib/leipreachan/mysql2.rb', line 8

def dbrestore! file
  password = db_config['password'].present? ? "-p#{db_config['password']} " : ""
  system("zcat < #{backup_base_on(backup_folder)}/#{file} | mysql -u#{db_config['username']} #{password}#{db_config['database']}")
end