#! /bin/sh # Does a MySQL backup of all databases, to stdout (gzipped) # # Requires MySQL user backup@localhost to have been created, WITH A PASSWORD # (and with SELECT and LOCK TABLES permission to *.*). # In addition, /root/.my.cnf needs to have been created with mode 600 # containing the following: # # [mysqldump] # password= if [ x$1 = x-c ] ; then $mysqldump -u backup -A --ignore-table=mysql.event | gzip else $mysqldump -u backup -A --ignore-table=mysql.event fi ## --events