I just got the same problem, here's how you fix it:
open /etc/my.cnf in your favorite editor
under the heading [mysqld] add the term "max_allowed_packet=16M" (if
you are using a version before version 4, "set-variable =
max_allowed_packet=16M")
restart mysqld
If you want to restart from the beginning (the easiest way), open
mysql and delete cur then start again
If you want to try to start from where you left off, type:
wc -l 20040817_cur_table.sql
this will give you a line count, now subtract 1035 from that line
count to get the number of lines left in the file that need to be
processed, we'll call this "linesleft". now type the below command
replacing lines with linesleft
tail 20040817_cur_table.sql --lines=(linesleft) >> newtable.sql
now type:
mysql -u root -p<password> wiki-en < newtable.sql;
As I said before, just deleting the data and restarting is easier
Hope this helps
On 4/20/05, mm <mt1900(a)rdslink.ro> wrote:
I am trying to load cur_table.sql
mysql -u root -p<password> wiki-en < <directory>/20040817_cur_table.sql;
ERROR at line 1035:
I get this error after 1.5 hour. I try this 3 time and with 2 copy of sql file from two
distinct DVD.
I want to know if i can do something to skip the error and execute the rest of the
script.
I want to know how much of the job have been done.
If anyone can help please do it.
Thanks,
MM
_______________________________________________
Wikitech-l mailing list
Wikitech-l(a)wikimedia.org
http://mail.wikipedia.org/mailman/listinfo/wikitech-l