Re: How can i Import 10GB file in Workbench
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/
Subject
Views
Written By
Posted
814
August 20, 2019 01:28AM
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.