#913 Import schema from Mysql Workbench

[Fabrice Piccinali]

Mysql workbench is available at mysql.com and allows to
draw a very nice relationship diagram.

It would be great to have an import diagram from
workbench to phpmyadmin.

Workbench saves diagrams as XML file.

I am ready to write a converter but i need help in
order to integrate into phpmyadmin :
- what is the xml parser you recommend ?
- where can i put my script ? (inside pdf_pages.php ?)

I see something like :
- a form selects and loads the xml files
- a parser extract the list of tables and relations
- some INSERT in pma_relation
- some INSERT in pma_pdfpages and pma_tablescoords

[Michal Čihař]

Logged In: YES
user_id=192186

Thanks for your interest.

You should code plugin that would live in libraries/import/.
You don't need to care about file selecting, upload,
decompression and other stuff, just convert the data to SQL.

I won't help with xml parser in php, that's completely
unknown area to me.

[Michal Čihař]

Logged In: YES
user_id=192186

Any progress with this? Do you need any help?

[Fabrice Piccinali]

Logged In: YES
user_id=1511743

i am in stand by, the release 1.06 of mysqlworkbench is buggy.
Too many problem with print and export. you need a specific
hardware in order to obtain a print.
It is not helpful for testing.

There is also a thread in the forum about the xml file format.

I am waiting the next release of workbench to start my plugin.

Thank for your help

[Michal Čihař]

Logged In: YES
user_id=192186

If you're still interested in this, you can use docSQL
import plugin as reference, it does much simmilar thing (at
least it looks so for me with almost none knowledge of both
those tools).

[Fabrice Piccinali]

Logged In: YES
user_id=1511743

thanks for the advice, i am going to see docSQL