mysqldump:无法执行. information_schema中的未知表'column_statistics'

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.sqlThrows errors :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=0It'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'的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持！