I insert a sql statment, size is 30M, a field type is longtext
using
mysql dbname < filename
in file, it is a sql as insert into table ... values ...
where file size is 10 M, it execute well, but report error when file size is to 30M
it report:
ERROR 2006 at line 1: MYSQL server has gone away.
I have already set max_allowed_packet=80M, and wait_timeout=288000000,
delayed_insert_timeout=10000, connect_timeout=1000.
How can I do now?
Thanks advance.
>
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
