MySQL Forums
Forum List  »  MySQL Workbench

Re: How can i Import 10GB file in Workbench
Posted by: Mike Lischke
Date: August 21, 2019 01:10AM

You didn't mention how you tried the import, but the secret here is that such a file must be split into individual statements and those are executed one by one.

That's usually done by the client tools (MySQL command line, MySQL shell, MySQL Workbench). In Workbench open your connection, switch to the Administration pane and click on "Data Import/Restore". On the Data Import page you can select a folder or a single file to import. Specify your dump file here and click "Start Import".

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: How can i Import 10GB file in Workbench
599
August 21, 2019 01:10AM


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.