http://sourceforge.net/projects/automysqlbackup/ mkdir automysqlbackup cd automysqlbackup wget http://sourceforge.net/projects/automysqlbackup/ tar -zxvf download ./install.sh mkdir /var/backup mkdir /var/backup/db   vi /etc/automysqlbackup/myserver.conf ******************************************************************************************* # Basic Settings # Username to access the MySQL server e.g. dbuser CONFIG_mysql_dump_username=’root’ # Password to access the MySQL server e.g. password CONFIG_mysql_dump_password=’Everest01′ # Host name (or IP address) of MySQL server e.g localhost CONFIG_mysql_dump_host=’localhost’ CONFIG_db_names=() CONFIG_db_exclude=( ‘information_schema’ ‘performance_schema’ ) ********************************************************************************************** /usr/local/bin/automysqlbackup /etc/automysqlbackup/myserver.conf   If we get error  

Warning: Skipping the data of table mysql.event.

  vi /etc/mysql/my.cnf add events ignore-table=mysql.events   [mysqldump] quick quote-names max_allowed_packet = 16M events ignore-table=mysql.events [mysql]   ADD CRON JOB crontab -e 13 23 * * * /usr/local/bin/automysqlbackup /etc/automysqlbackup/myserver.conf   this run the backup script every night at 11:13 PM