Hello, I'm having problems importing the cur en.wikipedia.org dump into my local MySQL server. I get the "max_allowed_packet" problem, but increasing the value of that variable doesn't fix things for me. I'm clearly doing something silly, but can't figure out what. I'd appreciate any suggestions anyone may have.
==Details== I'm running a clean install of MySQL 4.0.16-nt on Windows XP SP2, with mediawiki 1.4.2 installed and working okay.
c:\WINDOWS\my.ini has the line: set-variable=max_allowed_packet=512M
I've restarted the MySQL service since setting the above value.
I downloaded the April 21st cur table dump from http://download.wikimedia.org/ and tried to load it with the following command (where mysql and the mysql service run on the same machine):
mysql --max_allowed_packet=512M -u dan -p -D wikidb < 20050421_cur_table.sql
A nerve-wracking 7hrs later I get the (now all too familiar): ERROR 1153 at line 1323: Got a packet bigger than 'max_allowed_packet'
I can only imagine that somehow the max packet setting isn't being honoured by someone along the line. Naturally I tried it at the more modest values suggested by http://en.wikipedia.org/wiki/Wikipedia:Database_dump_import_problems, but even bumping it up to the (surely insane) heights of 512M didn't help.
I looked through the .sql file with less and it seems valid and uncorrupted.
Thanks, Dan McDonald (user:Middenface)