More than 5 years have passed since last update.

MySQLでクライアント(v8)からサーバー(v5.7)でのDumpファイル取得方法

MySQL

Posted at 2019-12-02

# 実行
mysqldump --column-statistics=0 -u root -p -h [HOST] [DB]  > dump.txt
# エラー
mysqldump: Couldn't execute 'SELECT COLUMN_NAME,                      
JSON_EXTRACT(HISTOGRAM, '$."number-of-buckets-specified"')                
FROM information_schema.COLUMN_STATISTICS                
WHERE SCHEMA_NAME = '[DB]' AND TABLE_NAME = 'action_histories';'
: Unknown table 'COLUMN_STATISTICS' in information_schema (1109)

--column-statistics=0をパラメタ指定することで実行できるようになる`

mysqldump --column-statistics=0 -u root -p -h [HOST] [DB]  > dump.txt

You get articles that match your needs
You can efficiently read back useful information
You can use dark theme

What you can do with signing up