English 中文(简体)
Is it possible to save MySQL Workbench files as plain XML?
原标题:

DB Designer had a lot of bugs but one outstanding feature was that database models were saved in plain XML by default.

This allowed a user to diff file versions via SVN or Beyond Compare, easily finding any changes made to the database.

Unfortunately, DB Designer s succsssor, MySQL Workbench, stores files in a proprietary MVW file format, which is unreadable.

Is it possible to force MySQL Workbench to save as XML?

最佳回答

No, the current version (5.2.10 beta) does not support that.

However, the file format is not proprietary - its a simple zip archive. It contains a single XML document which is the complete database model. I wrote this SO question a couple of months ago with the same goal as you seem to have. I wanted to be able to do svn diff model.mwb

The answer I got there helped me write a small script which unzipped the file before passing it to the diff tool. It worked decently and if you re interested I can post it somewhere.

I also very recently started a thread on the Workbench forum about this issue. Hopefully someone on the development team can provide some more input on this.

EDIT: it is now being tracked by MySQL Bug #51203 with a target of 6.0.

问题回答

暂无回答




相关问题
SQL SubQuery getting particular column

I noticed that there were some threads with similar questions, and I did look through them but did not really get a convincing answer. Here s my question: The subquery below returns a Table with 3 ...

please can anyone check this while loop and if condition

<?php $con=mysql_connect("localhost","mts","mts"); if(!con) { die( unable to connect . mysql_error()); } mysql_select_db("mts",$con); /* date_default_timezone_set ("Asia/Calcutta"); $date = ...

php return a specific row from query

Is it possible in php to return a specific row of data from a mysql query? None of the fetch statements that I ve found return a 2 dimensional array to access specific rows. I want to be able to ...

Character Encodings in PHP and MySQL

Our website was developed with a meta tag set to... <meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1" /> This works fine for M-dashes and special quotes, etc. However, I ...

Pagination Strategies for Complex (slow) Datasets

What are some of the strategies being used for pagination of data sets that involve complex queries? count(*) takes ~1.5 sec so we don t want to hit the DB for every page view. Currently there are ~...

Averaging a total in mySQL

My table looks like person_id | car_id | miles ------------------------------ 1 | 1 | 100 1 | 2 | 200 2 | 3 | 1000 2 | 4 | 500 I need to ...

热门标签