使用MySQL Workbench CE导出数据库的数据字典？ [英] Export Data Dictionary of my database using MySQL Workbench CE?

问题描述

我有一个数据库在服务器上有大约60个表，现在我想要导出数据库的数据字典（包括表结构）..

我可以在我的本地机器上执行此操作，该机器具有 PHPMyAdmin ，但是，我无法找到方法在服务器上使用 Workbench 。

任何可以帮助的人？

解决方案

您可以安装db_doc.lua，一个用于生成数据字典的MySQL Workbench的Lua脚本插件，类似于DBDoc在MySQL Workbench Enterprise上生成的脚本。

下载：
https：// docs.google.com/file/d/0BxXM2ftdUPGeNkM4OGpiYmFxdFk/edit?pli=1

插件开发人员网站
http://tmsanchezdev.blogspot.mx/2013/11

>似乎LUA插件支持已停止。
所以我在Python中编写了一个插件来生成数据字典。
可从以下网址获取： https://github.com/rsn86/MWB-DBDocPy

I have a database on server with around 60 tables and now I want to export Data Dictionary of the database (including table structures)..

I can do that on my local machine which has PHPMyAdmin, however, I am not able to find way to export it on server using Workbench.

Any one who can help?

解决方案

You may install db_doc.lua, a Lua script plugin for MySQL Workbench that generates data dictionaries, similar to those generated by DBDoc on MySQL Workbench Enterprise.

Download it from: https://docs.google.com/file/d/0BxXM2ftdUPGeNkM4OGpiYmFxdFk/edit?pli=1

Plugin developer's website http://tmsanchezdev.blogspot.mx/2013/11/reporte-actualizado-del-modelo-de-la.html

[EDITED]

It seems that the LUA plugin support was discontinued. So I wrote a plugin in Python to generate data dictionaries. It is available at: https://github.com/rsn86/MWB-DBDocPy

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