Re: convert database items into text file

[Michael G. Zinner]

Ad 1) Right click in the Catalog palette (on the right where the schemata are listed) and select to create a new schema. After you have created the schema, right click on that and select to create a table.

Then the Table Editor will appear and you can create a table like you are used to from MySQL Workbench.


Ad 2) In order to connect to a MySQL Server you need MySQL Workbench Standard Edition. If you want to stick to the Community Edition you have to export the schemata you see in MySQL Query Browser to an SQL CREATE script first. You can do that with MySQL Administrator or mysqldump. In MySQL Workbench you can choose File -> Import to reverse engineer that database from the SQL CREATE file.

When you made your changes you can export as SQL CREATE script or SQL ALTER script via File -> Export. This file can then be executed using MySQL Query Browser from a script tab.

Michael Zinner, Team Lead, Developer Tools
MySQL AB, www.mysql.com

Are you MySQL certified? www.mysql.com/certification