Problems creating world database (rev 709)

[shargash]

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

[Lokked]

The reason for this is that MySQL default install only allows a certain size of query to be run against it.

I thought I posted about this, but I can't find it.

Check this SO post out:
http://stackoverflow.com/questions/8062 ... acket-size

Your error is different than the OP, but this is the issue. Here is more information:
http://dev.mysql.com/doc/refman/5.0/en/ ... ction.html

[Blackstorm]

Hi,

I always import through phpmyadmin with a POST var size at 25MB (the currently script size is aprox. 17MB) and have no error.
Maybe you need to increase the post var size too, or optimize your mysql settings to accept more requests size...

[shargash]

Thanks, guys. I'm pretty much a novice at db stuff, and I've never used MySql before. I did check the online help, but couldn't find anything that looked relevant.

[Lokked]

Find you my.ini file. There is also some command prompt line you can run to increase this limit, but I think it is just for that session (it will reset to default when next you run the MySQL process).

[shargash]

I changed max_allowed_packet=4M in the %programdata% version of my.ini to max_allowed_packet=32M, and the inserts executed fine. Thanks again!