Last active
March 8, 2024 04:26
-
-
Save trafficinc/a0b7cfa58a00e794bf8c7dd0626c2765 to your computer and use it in GitHub Desktop.
Python script for taking mysqldump
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
#!/usr/local/bin/python3 | |
""" | |
Will backup all the databases listed, will put files in same DIR as script' | |
To run: $ python dbbackup.py OR python3 dbbackup.py | |
""" | |
import configparser | |
import os | |
import time | |
import getpass | |
HOST='localhost' | |
PORT='3306' | |
DB_USER='username' | |
DB_PASS='password' | |
# if using one database... ('database1',) | |
databases=('database1','database2','database3') | |
def get_dump(database): | |
filestamp = time.strftime('%Y-%m-%d-%I') | |
# D:/xampp/mysql/bin/mysqldump for xamp windows | |
os.popen("mysqldump -h %s -P %s -u %s -p%s %s > %s.sql" % (HOST,PORT,DB_USER,DB_PASS,database,database+"_"+filestamp)) | |
print("\n|| Database dumped to "+database+"_"+filestamp+".sql || ") | |
if __name__=="__main__": | |
for database in databases: | |
get_dump(database) |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment
I'm having an empty file of 0kb when I run on the Windows task scheduler, but when run on cmd it backups the database with content in file