This mysql database shell (bash download link at the end of script) script can be used:
1) To backup databases file /backup dir and later pick up by your script
2) You can skip few databases from backup!
Download script from above url.
Open file backup.bash.txt and customize it:
MyUSER=”YOUR-MYSQL-USER” # mysql username
MyPASS=”YOUR-MYSQL-USER-PASSWORD” # mysql password
MyHOST=”localhost” # mysql Hostname
Optional setup the name of database which you do not wish to backup:
IGGY="test db2 db3"
Rename backup.bash.txt file to mysqlbackup.bash and execute it as follows
You may need to setup a cron job to take backup everyday.