Win a copy of The Little Book of Impediments (e-book only) this week in the Agile and Other Processes 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
Hi,

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