mariadb backup script
-
mariadb remote backup python script using mysqldumpMysql, Maria DB 2020. 5. 11. 13:04
import pymysql from os import system from datetime import datetime host = ' ' dbuser = ' ' password = ' ' dbname = ' ' # get tables name conn = pymysql.connect(host=host, user=dbuser, password=password,db=dbname) c = conn.cursor() c.execute('SHOW TABLES') tablelist = [ x[0] for x in c.fetchall() ] c.close() conn.close() # mysqldump.exe backup (prefix_date) prefix_date = str(datetime.today().date..