Multiple Databases Backup: To take multiple databases backup, create an text file like /backup/dbnames.txt and add databases names one per line like below
# cat /backup/dbnames.txt
database1
mydb
And add this file to script like below.
DB_NAME = '/backup/dbnames.txt'
Change Backup Location: You can change below variable to change the location of backup path.
BACKUP_PATH = '/backup/dbbackup/'
Download Script:
# wget
sourceforge.net/projects/mysqldumppython/files/dbbackup.py
How to Execute Script:
After downloading script make the script executable using following command
# chmod +x dbbackup.py
and execute this script like below
# python dbbackup.py
You can also schedule this script to run daily on regular interval using crontab. Add below command in crontab.
0 2 * * * /usr/bin/python dbbackup.py
Download Script:
