Theresa Arzadon-Labajo | ||||
Menu:
Powered by Website Baker |
The error occurs because of the mysql.general_log and mysql.slow_log tables. One can exclude these tables in the configuration file, with: CONFIG_table_exclude=( 'mysql.general_log' 'mysql.slow_log') or exclude the whole database with: CONFIG_db_exclude=( 'mysql' ) However, the script was still reporting the error. This is due to the full schema backup which specifically defines '--all-databases' in the automysqlbackup script: opt_fullschema=( '--all-databases' '--routines' '--no-data' ) Add the '--lock-tables=0' option and the error will no longer appear. opt_fullschema=( '--all-databases' '--routines' '--no-data' '--lock-tables=0' ) It probably would be better if automysqlbackup would exclude the mysql database or log tables instead.
Last changed: Feb 27 2020 at 4:03 PM Back |
|||