将docker容器中mysql数据库导出到服务器本地

将docker中的数据库备份

docker exec -i [镜像名] /usr/bin/mysqldump --column-statistics=0 -u [用户名] -p[密码(和-p连在一起)] [数据库名] > export.sql(backup.sql导出的文件名)

如：

docker exec -i mysql /usr/bin/mysqldump -u root -p123456 csdb > /path/to/export.sql

附：

**

出现错误：

**mysqldump: [Warning] Using a password on the command line interface can be insecure. mysqldump: Couldn't execute 'SELECT COLUMN_NAME, JSON_EXTRACT(HISTOGRAM, '$."number-of-buckets-specified"') FROM information_schema.COLUMN_STATISTICS WHERE SCHEMA_NAME = 'cdmsdb' AND TABLE_NAME = 'desk_params_settings';': Unknown table 'column_statistics' in information_schema (1109)

解决方法：

添加--column-statistics=0

docker exec -i mysql /usr/bin/mysqldump --column-statistics=0 -u root -p123456 csdb > /path/to/export.sql