Error in executing mysqldump for 8.0

  Snippets, Technology, Database, MySQL snippets, MySQL

In attempting to use the mysqldump utility provided with MySQL 8.x against a 5.7 server, you may receive the following error message:

mysqldump: Couldn't execute 'SELECT COLUMN_NAME, JSON_EXTRACT(HISTOGRAM, '$."number-of-buckets-specified"')

This is due to the INFORMATION_SCHEMA in 8.0 having more columns to support several new features in 8.x.  This error can be silenced by adding the following parameter to the mysqldump command line:

--column-statistics=0

 

Related posts:

  1. Dump MySQL triggers and routines, no data
  2. Sizing and report scripts
  3. Detecting and killing duplicate queries
  4. MySQL integer audit
  5. MySQL DDL diff