关于mysqldump和microsoftazure的问题

s71maibg  于 2021-06-20  发布在  Mysql
关注(0)|答案(1)|浏览(384)

我需要转储在microsoft azure上托管的数据库。
我试着做到:
1使用mysql workbench连接数据库。
2选择数据导出并使用它。警告信息显示“mysqldump(8.0.12)和要转储的mysql服务器(5.7.21)的版本不一致可能导致问题”。
三。mysql社区安装程序没有可用的升级。
那么问题出在哪里:
1如何获取所需版本的mysqldump?
2mysqldump版本似乎比需要的版本要高,但它仍然不起作用。为什么?
所有尝试都有以下日志:

18:59:01 Dumping schedule-system (all tables)
Running: "C:\Program Files\MySQL\MySQL Server 8.0\bin\mysqldump.exe" --defaults-file="c:\users\myrce\appdata\local\temp\tmp2jqnwp.cnf"  --user=jesper@omsu-projects --host=omsu-projects.mysql.database.azure.com --protocol=tcp --port=3306 --default-character-set=utf8 --skip-triggers "schedule-system"
mysqldump: Couldn't execute 'SELECT COLUMN_NAME,                       JSON_EXTRACT(HISTOGRAM, '$."number-of-buckets-specified"')                FROM information_schema.COLUMN_STATISTICS                WHERE SCHEMA_NAME = 'schedule-system' AND TABLE_NAME = 'classroom';': Unknown table 'column_statistics' in information_schema (1109)

Operation failed with exitcode 2
18:59:06 Dumping recruiting-server (all tables)
Running: "C:\Program Files\MySQL\MySQL Server 8.0\bin\mysqldump.exe" --defaults-file="c:\users\myrce\appdata\local\temp\tmpobvhuq.cnf"  --user=jesper@omsu-projects --host=omsu-projects.mysql.database.azure.com --protocol=tcp --port=3306 --default-character-set=utf8 --skip-triggers "recruiting-server"
mysqldump: Couldn't execute 'SELECT COLUMN_NAME,                       JSON_EXTRACT(HISTOGRAM, '$."number-of-buckets-specified"')                FROM information_schema.COLUMN_STATISTICS                WHERE SCHEMA_NAME = 'recruiting-server' AND TABLE_NAME = 'companies';': Unknown table 'column_statistics' in information_schema (1109)

Operation failed with exitcode 2
18:59:10 Export of C:\Users\myrce\Desktop\data.sql has finished with 2 errors
wkyowqbh

wkyowqbh1#

嗨,杰斯珀,我想你使用一个azure数据库的mysql服务器。我也用它,我也有同样的问题。我解决问题的步骤:
卸载workbench并安装最新版本8.0.12
从下载5.7.21https://downloads.mysql.com/archives/community/
在workbench path:edit/preferences/administration中,我从mysql 5.7.21下载并解压缩了mysqldump.exe。
记住在路径edit\preferences\sqleditor中定义长mysql会话超时

相关问题