Hi There,
i tried to load a big file into a MySQL table using LOAD DATA LOCAL INFILE ...
Everything worked fine but after about 2 hours it say:
Lost connection to MySQL- server during query
The server was allwaiys up and I don't have a clue what happend.
I thought, that maybe our intranet was down for a moment or it is something with
timeouts.
I rewrote the /etc/my.cnf file and raised the connect_timeout-variable to 1000.
After restartign the server, the variable was still 5, so I guess I did something
wrong.
So I have 3 questions:
How canI raise connect_timeout (if necessary) ?
Is it possible to get transparent reconnects with MySQL for a LOAD DATA INFILE
statement ?
Is there anything else, that I need to do.
MySQL is 3.23.52-log
Client api is mysqltcl 2.11 (based on C-api)
OS is SUSE-LINUX SES 8.0 Kernel 2.4
FS is Reiser up to 64 GB
tia
Klaus
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
