今天备份数据库,遇到1146错误。
[root@server-210 logs]# /usr/local/mysql/bin/mysqldump --single-transaction -uroot -pxxx --force --routines --triggers kls_archives >210_kls_archives_$(date +%F_%H).sql
Warning: Using a password on the command line interface can be insecure.
Error: Couldn't read status information for table PrepareList ()
mysqldump: Couldn't execute 'show create table `PrepareList`': Table 'kls_archives.preparelist' doesn't exist (1146)
mysqldump: Couldn't execute 'SHOW CREATE</