Problems creating world database (rev 709)
Posted: Tue Oct 14, 2014 9:07 pm
When I try to run the script vgo_world.sql (rev 709), I get errors trying to insert data into two tables, on the INSERT INTO `spawn_location_name` and INSERT INTO `spawn_location_placements` statements. The error I get is:
Preparing...
Importing vgo_world.sql...
Finished executing script
ERROR 2013 (HY000) at line 636: Lost connection to MySQL server during query
Operation failed with exitcode 1
I get the same error whether I try to Run SQL Script... or Open SQL Script... and execute.
The two inserts that fail are huge. If I break them up manually into 4 insert statements each, they complete OK. I figure I'm having a memory issue, except that I have 16gb RAM and a 32GB paging file, which I would think would be enough. I'm running MySql Community Server v5.6. Is there something else I should be running?
Thanks
Preparing...
Importing vgo_world.sql...
Finished executing script
ERROR 2013 (HY000) at line 636: Lost connection to MySQL server during query
Operation failed with exitcode 1
I get the same error whether I try to Run SQL Script... or Open SQL Script... and execute.
The two inserts that fail are huge. If I break them up manually into 4 insert statements each, they complete OK. I figure I'm having a memory issue, except that I have 16gb RAM and a 32GB paging file, which I would think would be enough. I'm running MySql Community Server v5.6. Is there something else I should be running?
Thanks