Mysql Operation failed with exitcode 2

mysqlOperationexitcode 2

09时59分19秒 Dumping xyg_db_dev (t_lottery) Running: /usr/lib/mysql-workbench/mysqldump --defaults-file="/tmp/tmptqL1Xr/extraparams.cnf" --user=root --host=127.0.0.1 --protocol=tcp --port=3306 --default-character-set=utf8 --no-data --skip-triggers "xyg_db_dev" "t_lottery" mysqldump: Couldn't execute 'SELECT COLUMN_NAME,
JSON_EXTRACT(HISTOGRAM, '$."number-of-buckets-specified"')
FROM information_schema.COLUMN_STATISTICS WHERE SCHEMA_NAME = 'xyg_db_dev' AND TABLE_NAME = 't_lottery';': Unknown table 'COLUMN_STATISTICS' in information_schema (1109)

Operation failed with exitcode 2 09时59分20秒 Export of /home/luke/dumps/Dump20180911 has finished with 1 errors

原因

备份数据库与workbench不兼容。

解决方案

1. workbench下 打开Edit--Preferences
2. 选择Administrator，里面第一项，Path to mysqldump Tool 选择自己的mysqldump

不知道在哪儿?简单粗暴!

 find / -name "mysqldump"

本站文章除注明转载/出处外，均为本站原创或翻译，转载前请务必署名,转载请标明出处
最后编辑时间为: 2019/05/28 10:53