class Container::Backup::Mssql
Public Instance Methods
backup()
click to toggle source
-
“backup={volumes: [drupal_mysql_data],databases: [mysql: {db: ${MYSQL_DATABASE},password: ${MYSQL_ROOT_PASSWORD},user: root}]}”
-
“backup.1={databases: [mysql: {db: ${MYSQL_DATABASE}2,password: ${MYSQL_ROOT_PASSWORD},user: root}]}”
# 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()
click to toggle source
# 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