abnormal client termination

2004-01-13 Thread jawahar . muthukrishnan
Scenario: Client gets a connection from MySQL. The client process is killed i.e. client does not close the connection to MySQL. Observation: When I use "Show ProcessList" command to look at all the open connections, the connection with the client (terminated abnormally) doesn't show up in the l

load data infile question

2003-10-02 Thread jawahar . muthukrishnan
In MYSQL documentation the following line is Some cases are not supported by LOAD DATA INFILE: 1. Fixed-size rows( FIELDS TERMINATED BY and FIELDS ENCLOSED BY both empty) and BLOB or TEXT columns I defined a column in a table as type TEXT. I then loaded values using LOAD DATA INFILE into the tabl