Mysql8.0备份脚本错误汇总1

windows下运行mysql8.0备份脚本：
set yy=%date:~0,4%
set mm=%date~5,2%
set dd=%date:~8,2%
set EACH_DATE=%yy%-%mm%-%dd%
set host=127.0.0.1
set port=3306
set user=root
set password=123456
set backupfile=C:/mysql_scripts/sqls/
mysqldump -h%host% -P%port% -u%user% -p%password% --databases test > %backupfile%test-%EACH_DATE%.sql
**报错：**mysqldump：【Warning】 Using a password on the command line interface can be insecure.
**解决：**MYSQL5.5之后的版本不允许将密码暴露在命令行，可在配置文件中写入用户名和密码，设置登录信息，cmd下输入命令：mysql_config_editor set --login-path=mall --host=127.0.0.1 --port=3306 --user=root -p
然后会提示输入密码，输入密码后按回车，配置信息设置完成，可以输入命令：mysql_config_editor print --all 查看配置信息
**报错：**mysqldump：Couldn’t execute ‘SELECT COLUMN_NAME,JSON_EXTRACT<HISTOGRAM, ‘$.“number-of buckets-specified”’> from information_schema.COLUMN_STATISTICS WHERE SCHEMA_NAME = ‘root’ ADN TABLE_NAME = ‘bigdata_capacity_config’;;’: Unknow table ‘COLUMN_STATISTICS’ in information_schema (1109)
**解决：**新版的mysqldump默认启用一个新标志，脚本中加入–column-statistics=0禁用
修改bat脚本后：
set yy=%date:~0,4%
set mm=%date~5,2%
set dd=%date:~8,2%
set EACH_DATE=%yy%-%mm%-%dd%
set backupfile=C:/mysql_scripts/sqls/
mysqldump --login-path=mall --column-statistics=0 --databases test > %backupfile%test-%EACH_DATE%.sql
运行成功