When using Wordmove to move a database, the following error message may appear
mysqldump: [Warning] Using a password on the command line interface can be insecure. (Wordmove::ShellCommandError)
mysqldump: Couldn't execute ' SELECT COLUMN_NAME, JSON_EXTRACT(HISTOGRAM, '$." number-of-buckets-specified"') FROM information_schema.COLUMN_STATISTICS WHERE SCHEMA_NAME = 'xxxxxxxxxxxx' AND TABLE_NAME = 'wp_commentmeta ';': Unknown table 'COLUMN_STATISTICS' in information_schema (1109)This error occurs because mysqldump is looking for the COLUMN_STATISTICS table, but the table does not exist. As a solution, add the following options to the Wordmove configuration file
database:
mysqldump_options: "--column-statistics=0"This option will cause mysqldump to ignore the COLUMN_STATISTICS table and no longer generate errors.
Reference: https://qiita.com/miya0001/items/e0625a160e3a36f18e1f