Class: Container::Backup::Mssql
- Defined in:
- lib/container/steps/databases.rb
Instance Method Summary collapse
-
#backup ⇒ Object
-
“backup=[drupal_mysql_data],databases: [mysql: {db: ${MYSQL_DATABASE,password: $MYSQL_ROOT_PASSWORD,user: root}]}” - “backup.1=[mysql: {db: ${MYSQL_DATABASE2,password: $MYSQL_ROOT_PASSWORD,user: root}]}”.
-
- #restore ⇒ Object
Methods inherited from Step
#backup_path, #container, #image, #initialize, #params, #perform
Constructor Details
This class inherits a constructor from Container::Backup::Step
Instance Method Details
#backup ⇒ Object
-
“backup=[drupal_mysql_data],databases: [mysql: {db: ${MYSQL_DATABASE,password: $MYSQL_ROOT_PASSWORD,user: root}]}”
-
“backup.1=[mysql: {db: ${MYSQL_DATABASE2,password: $MYSQL_ROOT_PASSWORD,user: root}]}”
23 24 25 26 27 28 29 |
# File 'lib/container/steps/databases.rb', line 23 def backup raise "not yet implemented #{self.class.name} backup step" # docker exec -it mssql /opt/mssql-tools/bin/sqlcmd -S ru-db.aegean.gr -U sa -P $mssql_root_password -d master -i /root/mssql/backup_mssql_dbs.sql #echo 'Press any key to copy backups to staging...'; #read -s -n1 #docker exec -it mssql /opt/mssql-tools/bin/sqlcmd -S ru-db.aegean.gr -U sa -P $mssql_root_password -d master -i /root/mssql/copy_mssql_dbs_to_staging.sql end |
#restore ⇒ Object
30 31 32 33 34 35 36 |
# File 'lib/container/steps/databases.rb', line 30 def restore raise "not yet implemented #{self.class.name} backup step" #stop #sh "docker exec -it mssql /opt/mssql-tools/bin/sqlcmd -S localhost -U sa -P %SA_PASSWORD% -d master -i /root/mssql/init.sql" #docker exec -it mssql /opt/mssql-tools/bin/sqlcmd -S localhost -U sa -P %SA_PASSWORD% -d master -i /root/mssql/map_logins.sql #start end |