MySQL Forums
Forum List  »  MySQL Workbench

Re: Move database from SQL to Workbench
Posted by: Mike Lischke
Date: June 15, 2009 01:39AM

Hey Stephen,

for not so experienced devs I think it is better to use one of the GUI tools we wrote to do tasks like dumps or other maintenance. See http://dev.mysql.com/downloads/gui-tools/5.0.html, where you can download a package for your platform (if supported). Once installed start MySQL Administrator, create a connection to your database server and go to the backup section. There you can easily select a schema or even a number of objects in different schemas and let them write into an SQL script, which then can be reverse engineered by MySQL Workbench.

You can then do your changes and use the dump you created in the first step to let WB create a new script that only contains the DDL for things that have changed. You can use MySQL Query Browser to execute this script (QB can be started directly from MA and vice versa, using the same db connection).

Mike

Mike Lischke, MySQL Developer Tools
Oracle Corporation

MySQL Workbench on Github: https://github.com/mysql/mysql-workbench
On Twitter: https://twitter.com/MySQLWorkbench
On Slack: mysqlcommunity.slack.com (#workbench)
Report bugs to http://bugs.mysql.com
MySQL documentation can be found here: http://dev.mysql.com/doc/refman/8.0/en/

Options: ReplyQuote


Subject
Views
Written By
Posted
Re: Move database from SQL to Workbench
1952
June 15, 2009 01:39AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.