Taking backup of MySQL database through email form crontab.

০১ লা এপ্রিল, ২০১৩ রাত ১২:১৯

please modify as per your requirement..



0 4 * * * /usr/bin/mysqldump --opt -u root –p rootpass db_name | gzip > /opt/ DB_Backup/database_name.sql.gz | /bin/echo "Your MySql DB backup successfully taken" | /bin/mail -s"MySQL DB network_complaint Backup Successfully Completed" [email protected] -c [email protected]



In this crontab example, the MySQL database dump shell script will be run every day, at four minutes after midnight. Once again, adjust this as desired.

০ টি +০/-০