Ask Your Question
4

What is the reason for mysqldump's failure and the error message "Unknown table 'column_statistics' in information_schema"?

asked 2021-12-08 11:00:00 +0000

huitzilopochtli gravatar image

edit retag flag offensive close merge delete

1 Answer

Sort by ยป oldest newest most voted
0

answered 2023-04-04 15:00:00 +0000

woof gravatar image

The reason for mysqldump's failure and the error message "Unknown table 'columnstatistics' in informationschema" is that the version of MySQL being used does not have the columnstatistics table in the informationschema database. This table was introduced in version 5.6.6 of MySQL, so if a version earlier than that is being used, the table will not exist and mysqldump will not be able to complete the backup. A possible solution to this issue is to upgrade the version of MySQL to one that includes the column_statistics table.

edit flag offensive delete link more

Your Answer

Please start posting anonymously - your entry will be published after you log in or create a new account. This space is reserved only for answers. If you would like to engage in a discussion, please instead post a comment under the question or an answer that you would like to discuss

Add Answer


Question Tools

Stats

Asked: 2021-12-08 11:00:00 +0000

Seen: 11 times

Last updated: Apr 04 '23