Module: MysqlAdapter
- Defined in:
- lib/adapters/mysql_adapter.rb
Instance Method Summary collapse
- #dump_all_databases_to_file(filename) ⇒ Object
- #dump_database_to_file(database, filename) ⇒ Object
- #restore_database_from_file(database, filename) ⇒ Object
Instance Method Details
#dump_all_databases_to_file(filename) ⇒ Object
3 4 5 6 |
# File 'lib/adapters/mysql_adapter.rb', line 3 def dump_all_databases_to_file(filename) # `mysqldump --user=root --password=yourrootsqlpassword --lock-all-tables \ # --all-databases > #{filename}` end |
#dump_database_to_file(database, filename) ⇒ Object
8 9 10 |
# File 'lib/adapters/mysql_adapter.rb', line 8 def dump_database_to_file(database, filename) # `mysqldump --opt -h hostname -u user -p password #{database} > #{filename}` end |
#restore_database_from_file(database, filename) ⇒ Object
12 13 14 |
# File 'lib/adapters/mysql_adapter.rb', line 12 def restore_database_from_file(database, filename) # `mysql - u user_name -p your_password #{database} < #{filename}` end |