RE: MYSQL DB PROBLEM
Hi This is a bug. You can fix it by adding a line to my.cnf. Can't remember what but search the archives as it has appeared before. Peter -Original Message- From: Nick Arnett [mailto:[EMAIL PROTECTED] Sent: 01 June 2003 15:54 To: [EMAIL PROTECTED] Subject: RE: MYSQL DB PROBLEM > -Original Message- > From: Adam Murphy [mailto:[EMAIL PROTECTED] > Sent: Saturday, May 31, 2003 10:48 PM > To: [EMAIL PROTECTED] > Subject: MYSQL DB PROBLEM > > > > I am trying to insert a table ibf_posts > > into a localhost database using the MYSQL control center every > time i try to insert that one table i get an error > > [forum] ERROR 2013: Lost connection to MySQL server during query Are you trying to insert a lot of data at once? If so, that will produce this error if it exceeds a certain size. The solutions are to insert fewer records at once or increase MAX_ALLOWED_PACKET, if I recall the correct variable. Nick -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: MYSQL DB PROBLEM
> -Original Message- > From: Adam Murphy [mailto:[EMAIL PROTECTED] > Sent: Saturday, May 31, 2003 10:48 PM > To: [EMAIL PROTECTED] > Subject: MYSQL DB PROBLEM > > > > I am trying to insert a table ibf_posts > > into a localhost database using the MYSQL control center every > time i try to insert that one table i get an error > > [forum] ERROR 2013: Lost connection to MySQL server during query Are you trying to insert a lot of data at once? If so, that will produce this error if it exceeds a certain size. The solutions are to insert fewer records at once or increase MAX_ALLOWED_PACKET, if I recall the correct variable. Nick -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: MYSQL DB PROBLEM
Hi Adam, there was a similar thread within the last 24 hours. try SHOW VARIABLES LKE '%time%'; Best regards Nils Valentin Tokyo/Japan 2003年 6月 1日 日曜日 14:47、Adam Murphy さんは書きました: > I am trying to insert a table ibf_posts > > into a localhost database using the MYSQL control center every time i try > to insert that one table i get an error > > [forum] ERROR 2013: Lost connection to MySQL server during query > > > > ?? > > pleas help > > Adam -- Valentin Nils Internet Technology E-Mail: [EMAIL PROTECTED] URL: http://www.knowd.co.jp -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]