适用于MySQL的Azure数据库的MySQL Workbench导出 [英] MySQL Workbench export of Azure Database for MySQL

问题描述

我一直试图在MacOS和Windows上使用MySQL Workbench进行数据库导出，

____

03:46:49抛弃voicewise_wp(所有表格)
运行:/Applications/MySQLWorkbench.app/Contents/MacOS/mysqldump --defaults-file ="/var/folders/3h/t02n5ysx2_z52db8twjsh9480000gn/T/tmpxJJ6y0/extraparams.cnf" --user = vw_admin_sql @ votewise --host = votewise.mysql.database.azure.com --protocol = tcp --port = 3306 --default-character-set = utf8 --skip-triggers"votewise_wp";
mysqldump:无法执行"SELECT COLUMN_NAME"，                       JSON_EXTRACT(HISTOGRAM，'$.指定的存储桶数"')               从 information_schema.COLUMN_STATISTICS                WHERE SCHEMA_NAME ='votewise_wp'AND TABLE_NAME ='wp_commentmeta';':information_schema中的未知表'column_statistics'(1109)

操作失败，退出代码为2
03:46:54/Users/seth/dumps/Dump20180830.sql的导出已完成，出现1个错误

___

我尝试安装旧版本的Workbench，因为它说最新的工作台具有mysqldump 8.x.x，Azure DB版本是5.x.x(现在不确定确切的数字).我之前已经成功完成了导出，而且我一无所知 出口的方式.我认为这应该可以按预期工作.

有人有什么主意吗?

解决方案

塞思，

请查看以下文档.它解释了完成此任务的两种方法.一个是命令行实用程序，另一个是使用MySQL Workbench.

通过使用导入和导出来迁移MySQL数据库

MySQL Workbench的导入/导出功能是针对表级别的，而不是针对整个数据库的.如果您还有其他问题，请告诉我们.此致，〜Mike

I've been trying to do a database export using MySQL Workbench on MacOS and Windows have been getting the following 

____

03:46:49 Dumping votewise_wp (all tables)
Running: /Applications/MySQLWorkbench.app/Contents/MacOS/mysqldump --defaults-file="/var/folders/3h/t02n5ysx2_z52db8twjsh9480000gn/T/tmpxJJ6y0/extraparams.cnf"  --user=vw_admin_sql@votewise --host=votewise.mysql.database.azure.com --protocol=tcp --port=3306 --default-character-set=utf8 --skip-triggers "votewise_wp"
mysqldump: Couldn't execute 'SELECT COLUMN_NAME,                       JSON_EXTRACT(HISTOGRAM, '$."number-of-buckets-specified"')                FROM information_schema.COLUMN_STATISTICS                WHERE SCHEMA_NAME = 'votewise_wp' AND TABLE_NAME = 'wp_commentmeta';': Unknown table 'column_statistics' in information_schema (1109)

Operation failed with exitcode 2
03:46:54 Export of /Users/seth/dumps/Dump20180830.sql has finished with 1 errors

___

I've tried to install an older version of Workbench since it says that the latest workbench has mysqldump 8.x.x and that the Azure DB version is 5.x.x (not sure the exact numbers now). I have successfully done an export before and I have no idea any other way to do an export. I would assume this should just work as expected.

Anyone got any ideas?

解决方案

Hi Seth,

Please take a look at the following documentation. It explains two methods for accomplishing this task. One is a command line utility and the other is using MySQL Workbench. 

Migrate your MySQL database by using import and export

The import/export functionality for MySQL Workbench is for table level and not entire database. Please let us know if you have additional questions. Regards, ~Mike

这篇关于适用于MySQL的Azure数据库的MySQL Workbench导出的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！