here's a python script to backup the database from docker and cp the files from docker to the folder of your choice, you will need to do a " pip3 install pymssql command first "
import os
import pymssql
SERVER_IP = "< DB IP HERE >"
SERVER_USERNAME = "< DB USERNAME HERE >"
SERVER_PASSWORD = "< DB PASSWORD HERE >"
DOCKER_FOLDER = "< CABAL DOCKER FOLDER >"
BACKUP_DIR = "< DIR YOU WANT TO CP BACKUP TOO >"
def get_backup_from_docker():
os.chdir(DOCKER_FOLDER)
print("getting backups from docker.")
os.system("docker-compose cp mssql:/home/Account.bak {0}/Account.bak".format(BACKUP_DIR))
os.system("docker-compose cp mssql:/home/Authentication.bak {0}/Authentication.bak ".format(BACKUP_DIR))
os.system("docker-compose cp mssql:/home/CabalCash.bak {0}/CabalCash.bak".format(BACKUP_DIR))
os.system("docker-compose cp mssql:/home/CabalGuild.bak {0}/CabalGuild.bak ".format(BACKUP_DIR))
os.system("docker-compose cp mssql:/home/EventData.bak {0}/EventData.bak ".format(BACKUP_DIR))
os.system("docker-compose cp mssql:/home/NetcafeBilling.bak {0}/NetcafeBilling.bak ".format(BACKUP_DIR))
os.system("docker-compose cp mssql:/home/Server01.bak {0}/Server01.bak ".format(BACKUP_DIR))
def backup_database():
conn = pymssql.connect(SERVER_IP, SERVER_USERNAME, SERVER_PASSWORD)
conn.autocommit(True)
cursor = conn.cursor()
cursor.execute("BACKUP DATABASE [Account] TO DISK = N'/home/Account.bak';")
conn.commit()
cursor.execute("BACKUP DATABASE [Authentication] TO DISK = N'/home/Authentication.bak';")
conn.commit()
cursor.execute("BACKUP DATABASE [CabalCash] TO DISK = N'/home/CabalCash.bak';")
conn.commit()
cursor.execute("BACKUP DATABASE [CabalGuild] TO DISK = N'/home/CabalGuild.bak';")
conn.commit()
cursor.execute("BACKUP DATABASE [EventData] TO DISK = N'/home/EventData.bak';")
conn.commit()
cursor.execute("BACKUP DATABASE [NetcafeBilling] TO DISK = N'/home/NetcafeBilling.bak';")
conn.commit()
cursor.execute("BACKUP DATABASE [Server01] TO DISK = N'/home/Server01.bak';")
conn.commit()
conn.close()
backup_database()
get_backup_from_docker()