mysqldump:无法执行. information_schema中的未知表'column_statistics' [英] mysqldump: Couldn't execute. Unknown table 'column_statistics' in information_schema

问题描述

我想转储数据库，即使遵循正确的语法，也会出现以下错误.

我使用的语法:

mysqldump -uroot -p omnichannel_store_india > omnichannel_store_india.sql

引发错误:

mysqldump:无法执行 "SELECT COLUMN_NAME，JSON_EXTRACT(HISTOGRAM，'$.指定的桶数"')来自information_schema.COLUMN_STATISTICS，其中SCHEMA_NAME ='omnichannel_store_india'和TABLE_NAME ='consignment_items';':

信息表(1109)中的未知表'column_statistics'

解决方案

这是由于在mysqldump 8中默认启用了"column-statistics"标志.您可以通过添加--column-statistics = 0来禁用它.

该命令将类似于:

mysqldump --column-statistics=0 --host=<server> --user <user> --password <securepass> 

默认情况下，要禁用列统计信息，可以在MySQL配置文件(例如/etc/my.cnf或〜/.my.cnf)中添加以下内容.

[mysqldump]

column-statistics=0

对我来说很棒.

有关列统计"的更多详细信息

在输出中添加ANALYZE TABLE语句，以便在重新装入转储文件时为转储表生成直方图统计信息.默认情况下，此选项是禁用的，因为大型表的直方图生成可能会花费很长时间. 参考( mysql官方文档链接)

I want to dump my database, even after following correct syntax it thows me following error.

Syntax I used :

mysqldump -uroot -p omnichannel_store_india > omnichannel_store_india.sql

Throws errors :

mysqldump: Couldn't execute 'SELECT COLUMN_NAME, JSON_EXTRACT(HISTOGRAM, '$."number-of-buckets-specified"') FROM information_schema.COLUMN_STATISTICS WHERE SCHEMA_NAME = 'omnichannel_store_india' AND TABLE_NAME = 'consignment_items';':

Unknown table 'column_statistics' in information_schema (1109)

解决方案

This is due to a flag "column-statistics" that is enabled by default in mysqldump 8. You can disable it by adding --column-statistics=0.

The command will be something like:

mysqldump --column-statistics=0 --host=<server> --user <user> --password <securepass> 

To disable column statistics by default, you can add following in a MySQL config file, such as /etc/my.cnf or ~/.my.cnf.

[mysqldump]

column-statistics=0

It's brilliantly work for me.

More details about "column-statistics"

Add ANALYZE TABLE statements to the output to generate histogram statistics for dumped tables when the dump file is reloaded. This option is disabled by default because histogram generation for large tables can take a long time. Ref ( mysql official documentaion link )

这篇关于mysqldump:无法执行. information_schema中的未知表'column_statistics'的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！