Erica, Thursday, October 17, 2002, 12:24:53 PM, you wrote: ED> I have three large files containing MySQL commands. However, when ED> importing them using mysql -u [username] -p [database] < file.sql, I get ED> an error:
ED> ERROR 2006 at line xxx: MySQL server has gone away >From reading more at mysql.com, it seems that MySQL reads these large ED> packets as errors on the part of the client and hangs up. Well, they're ED> not errors, just really large files! ;) Any idea how to fix this? ED> I use MySQL 3.23.52-Max installed as an RPM on Red Hat 7.3. In 3.23 you can't send packets bigger that 16M. Don't use extended inserts in this case. -- For technical support contracts, goto https://order.mysql.com/?ref=ma02-010c This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ ____ __ / |/ /_ __/ __/ __ \/ / Egor Egorov / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net <___/ www.mysql.com --------------------------------------------------------------------- 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