MySQL Forums
Forum List  »  MySQL Workbench

Re: How do I open an existing DB which I created using Query Browser
Posted by: Mike Lischke
Date: March 11, 2009 01:27AM

Hey Peter,

what version of Workbench do you use? There are 2 of which only the standard edition (SE) can directly work with database servers. The freely downloadable version (OSS) does not support life connections, so you have to go the way via SQL scripts. That means:

1) Export the schema you want to work on (MA, mysqldump, phpMySQLAdmin etc.).
2) Reverse engineer (import) this script in WB.
3) Edit your model.
4) Export (forward engineer) the model into an SQL script.

You can use MySQL Administrtaor to save and load srcipts easily.

Regarding your other question: not QB stores your databases but the database server does this. QB only sends commands to manipulate the meta data (e.g. tables, views, columns, indices etc.) as well as actual data in your tables. Hence, not QB but your server decides where to store this data. So, look through the MySQL documentation to find this out.

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/



Edited 2 time(s). Last edit at 03/18/2009 01:41AM by Mike Lischke.

Options: ReplyQuote


Subject
Views
Written By
Posted
Re: How do I open an existing DB which I created using Query Browser
3339
March 11, 2009 01:27AM


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.