1未命名0

Unknown table 'COLUMN_STATISTICS' in information_schema (1109)

柳三千

文章最后更新时间：2025年06月12日

报错信息

mysqldump: Couldn't execute 'SELECT COLUMN_NAME, JSON_EXTRACT(HISTOGRAM, '$.\"number-of-buckets-specified\"') FROM information_schema.COLUMN_STATISTICS WHERE SCHEMA_NAME = 'zabbix' AND TABLE_NAME = 'acknowledges';': Unknown table 'COLUMN_STATISTICS' in information_schema (1109)

解决办法

添加 --column-statistics=0 参数禁用列统计信息的导出。

修改后的命令示例

mysqldump --column-statistics=0 -u用户名 -p密码 数据库名 > 备份文件.sql
文章版权声明：除非注明，否则均为柳三千运维录原创文章，转载或复制请以超链接形式并注明出处。

相关阅读

  • Linux的root密码正确却无法登录服务器
  • Unknown table 'COLUMN_STATISTICS' in information_schema (1109)
  • FATAL ERROR: please install the following Perl modules before executing ./scripts/mysql_install_db:
  • Starting MySQL.The server quit without updating PID file (/[FAILED]l/mysql5.6/mysqld.pid).
  • error while loading shared libraries: libtinfo.so.5: cannot open shared object file
  • Starting MySQL.The server quit without updating PID file (/[FAILED]l/mysql/mysqld.pid)
  • error while loading shared libraries: libaio.so.1
  • CMake Error at libmysqld/cmake_install.cmake:36 (FILE): file INSTALL cannot copy file
    • 取消
    微信二维码
    微信二维码
    支付宝二维码