Export Data Dictionary of my database using MySQL Workbench CE?

mysql export mysql-workbench data-dictionary
Ghazanfar Mir picture Ghazanfar Mir · Sep 17, 2014 · Viewed 12k times · Source

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?

Answer

rsn86 picture rsn86 · Nov 2, 2014

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

Related questions

mysqlworkbench giving version error on exporting database

When I try to export my database through MySQL Workbench remotely from localserver, I am getting some below version error: mysqldump Version Mismatch [Content] mysqldump.exe is version 5.5.16, but the MySQL Server to be dumped has version 5.6.10-log. Because the …

Read More
Can't export my database from mysql workbench

I am trying to export my database from MySQL Workbench but I get this during the export progress: Running: mysqldump.exe --defaults-file="c:\users\user\appdata\local\temp\tmp2h91wa.cnf" --user=root --host=localhost --protocol=tcp --port=3306 --default-character-set=…

Read More
Export MySQL data to Excel in PHP

I'm trying to get my MySQL data to Excel file, but I'm having problems with Excel cells. All my text goes to one cell, I would like to have each row value in separate Excel cell. Here is my code: $…

Read More