MySQL Forums
Forum List  »  MySQL Workbench

Re: importing table dump from another machine
Posted by: Mike Lischke
Date: November 16, 2010 02:29AM

Hi Monte,

when you run a script in the SQL IDE that adds or removes db objects (and yes the more general term "schema" is what others name "database") you won't see those changes automatically. Instead you have to manually refresh the object listing (see context menu of the catalog treeview). This is to avoid lengthy refresh operations on slow connections or with many objects.

A better way to load a dump is however to use the WB Administration part. On the home screen create a server instance (see right column) and open it (double click the entry in the list after you created it). Go to the "Data Dump" tab and there on the "Import from Disk" tab.

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: importing table dump from another machine
1229
November 16, 2010 02:29AM


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.