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@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@wikimedia.org http://mail.wikipedia.org/mailman/listinfo/wikitech-l