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)