RE: MYSQL DB PROBLEM

2003-06-02 Thread Peter Lovatt
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

2003-06-02 Thread Nick Arnett
> -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

2003-06-01 Thread Nils Valentin
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]