Posts Tagged ‘Smart’
Daily/weekly/monthly Mysql database backup with cron
Monday, November 23, 2009 20:27 No CommentsSmart Mysql database backup with cron
Create and assign a DB user to the DB you want to backup with all privileges from your Cpanel >> Mysql section.
following is a simple script to take backup using cron. Just create the file, chmod it to 750 and execute it using cron.
#============================
#/bin/bash
/usr/bin/mysqldump –user=db_User –password=xyz –databases db_name | gzip [...]
