mkdir automysqlbackup cd automysqlbackup wget tar -zxvf download ./ 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   [mysqldump] quick quote-names max_allowed_packet = 16M 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