Re: How do I open an existing DB which I created using Query Browser

[Mike Lischke]

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.