Backing up MySQL used to be quick, easy and silent using mysqldump, but more recent versions of MySQL produce the following nagging warning: mysqldump -u root -p --all-databases --single-transaction > bak.sql Enter password: -- Warning: Skipping the data of table mysql.event. Specify the --events option explicitly. If you'd like

The following SQL will create a MySQL user with the minimum number of privileges necessary to backup databases: CREATE USER 'backup'@'localhost' IDENTIFIED BY '#PASSWORD#'; GRANT SELECT, RELOAD, FILE, SUPER, LOCK TABLES, SHOW VIEW ON *.* TO 'backup'@'localhost' IDENTIFIED BY '#PASSWORD#' WITH MAX_QUERIES_PER_HOUR