This week's giveaway is in the Programmer Certification (OCPJP) forum.
We're giving away four copies of Java Mock Exams (software) and have David Mayer on-line!
See this thread for details.
Win a copy of Java Mock Exams (software) this week in the Programmer Certification (OCPJP) forum!
  • Post Reply Bookmark Topic Watch Topic
  • New Topic

How to run a large DB script on MySQL

Jehan Jaleel
Ranch Hand
Posts: 196
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator

I know this is not Java related, but since this is my favorite forum I think I will post it here.

I am running MySQL Server 5.6 Community on Windows. I want to run a SQL script which is very large (about 3 GB) on one of the databases. I cannot even open the script in DBVisualizer (the tool I used to access mySQL), so I decided to run it from the Windows command line with the below...

But after a few minutes it gives the following error..

I believe it means the server timed out and closed the connection, but how to prevent it from doing so. The SQL file contains CREATE TABLE and INSERT INTO statements (basically it builds a client database locally), so I cannot run it multiple times

Does anyone have any suggestions on how to get around this?

Thanks in advance for any help.
  • Post Reply Bookmark Topic Watch Topic
  • New Topic
Boost this thread!