Re: max_allowed_packet error

2003-07-02 Thread Tina Motaye
No, nothing of the sort in the my.cnf file. :(

- Original Message - 
From: Dathan Vance Pattishall [EMAIL PROTECTED]
To: 'Tina Motaye' [EMAIL PROTECTED]; [EMAIL PROTECTED]
Sent: Tuesday, July 01, 2003 8:33 PM
Subject: RE: max_allowed_packet error


 Do you have a waittimeout set in you're my.cnf file? If so mysql would
 of forced closed a connection that it determines was inactive for 
 waittimeout seconds.
 
 
 ---Original Message-
 --From: Tina Motaye [mailto:[EMAIL PROTECTED]
 --Sent: Tuesday, July 01, 2003 5:28 AM
 --To: [EMAIL PROTECTED]
 --Subject: max_allowed_packet error
 --
 --hello,
 --
 --I'm exporting a very big table from ACCESS to MySQL using ODBC.
 --
 --I was able to do it by increasing the value of the max_allowed_packet
 --variable in mysql since otherwise ODBC lost the connection and I was
 --getting an error.
 --But the thing is I dropped the table for a test and now I'm not being
 --able to export it back.
 --
 --Wehn I try exporting from ACCESS I get the error :
 --(mysqld-4.013 -max-debug]Lost connection to MYSQL server during query
 --(#2013)
 --
 --I don't understand why I'm getting this again even if I change the
 value
 --of the max_allowed_packet!!
 --
 --Any help would be welcome.
 --
 --Thanks.
 
 

-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]



max_allowed_packet error

2003-07-01 Thread Tina Motaye
hello, 

I'm exporting a very big table from ACCESS to MySQL using ODBC. 

I was able to do it by increasing the value of the max_allowed_packet variable in 
mysql since otherwise ODBC lost the connection and I was getting an error. 
But the thing is I dropped the table for a test and now I'm not being able to export 
it back. 

Wehn I try exporting from ACCESS I get the error : 
(mysqld-4.013 -max-debug]Lost connection to MYSQL server during query (#2013) 

I don't understand why I'm getting this again even if I change the value of the 
max_allowed_packet!!

Any help would be welcome.

Thanks.