• Skip to primary navigation
  • Skip to main content
  • Skip to primary sidebar

I Like Kill Nerds

The blog of Australian Front End / Aurelia Javascript Developer & brewing aficionado Dwayne Charrington // Aurelia.io Core Team member.

  • Home
  • Aurelia 2
  • Aurelia 1
  • About
  • Aurelia 2 Consulting/Freelance Work

Fixing mysqldump unknown table COLUMN_STATISTICS

Databases · July 14, 2022

I am by no means a database guy. I am barely even a server guy. But, recently, I was tasked with exporting a sizeable database from Amazon RDS for use with local development servers.

After running the following mysqldump command:

mysqldump --host hostname -u username -p dbname > dbdump.sql

I am asked for the database password and then proceed to get an error complaining about an unknown table called COLUMN_STATISTICS. Unknown indeed, I had no idea what this table was even for or why mysqldump was trying to query it.

In a classic case of RTFM, I discovered that it’s some newly added thing in MySQL client 8.

mysqldump --column-statistics=0 --host hostname -u username -p dbname > dbdump.sql

We add the column-statistics flag to our command and set it to 0 to disable it, and the error goes away. The moral of the story is read the documentation.

Dwayne

Leave a ReplyCancel reply

0 Comments
Inline Feedbacks
View all comments

Primary Sidebar

Popular

  • Handling Errors with the Fetch API
  • How To Get The Hash of A File In Node.js
  • Thoughts on the Flipper Zero
  • How To Paginate An Array In Javascript
  • Testing Event Listeners In Jest (Without Using A Library)

Copyright © 2023 · Dwayne Charrington · Log in

wpDiscuz