Give permissions for every database to the backup user (you might not need lock tables).<\/p>\n
\r\nGRANT SELECT, LOCK TABLES ON *.* \r\n TO backupuser@host IDENTIFIED BY 'password';\r\n<\/pre>\n\r\ndbUser=\r\ndbHost=\r\ndbPass=\r\n\r\nfor db in $(mysql --user=$dbUser --host=$dbHost \\\r\n --password=$dbPass -Bse 'show databases')\r\ndo\r\n backupFile=sql\/$db.$(date +%F)-$(date +\"%T\").sql.gz\r\n mysqldump --add-drop-database --user=$dbUser \\\r\n --host=$dbHost --password=$dbPass \\\r\n $db | gzip -9 > $backupFile\r\ndone\r\n<\/pre>\n","protected":false},"excerpt":{"rendered":"Give permissions for every database to the backup user (you might not need lock tables). GRANT SELECT, LOCK TABLES ON *.* TO backupuser@host IDENTIFIED BY ‘password’; dbUser= dbHost= dbPass= for db in $(mysql –user=$dbUser –host=$dbHost \\ –password=$dbPass -Bse ‘show databases’) … Continue reading