Win a copy of Java 9 Modularity: Patterns and Practices for Developing Maintainable Applications this week in the Java 9 forum!
  • Post Reply Bookmark Topic Watch Topic
  • New Topic

How to run a large DB script on MySQL  RSS feed

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.
Consider Paul's rocket mass heater.
  • Post Reply Bookmark Topic Watch Topic
  • New Topic
Boost this thread!