Export Data Dictionary of my database using MySQL Workbench CE?

Question

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?

Check this link : http://dev.mysql.com/doc/workbench/en/wb-mysql-connections-navigator-management-data-export.html — Yatin Mistry, Sep 17 '14 at 13:59
I know data export - but I am after `Data Dictionary`, that is structure only of all tables including fields, fields type etc — Ghazanfar Mir, Sep 17 '14 at 14:01
Do you really know what Data Dictionary is? I am not after queries to create table.. I am after a list of tables that will show field names, field types and all other structure of tables — Ghazanfar Mir, Sep 17 '14 at 14:10

rsn86 · Answer 1 · 2014-11-03T01:03:13.490

4

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

edited Nov 03 '14 at 01:03

answered Nov 02 '14 at 18:58

rsn86

181
1
6

Thanks for writing the script – Michael Brenndoerfer Feb 24 '15 at 14:59

Export Data Dictionary of my database using MySQL Workbench CE?

1 Answers1

Linked