Hi list! I have a problem when trying to read data into tables with LOAD DATA LOCAL INFILE.
I get this error: ERROR 2013: Lost connection to MySQL server during query When looking at the MySQL site it says that I should increase the max_allowed_packet=# option (default 1M). However, my file is not that big, since it is only 226 byte. It also suggests that I should check the uptime of the mysqld, so I can verify that it hasn't crashed. issuing the 'mysqladmin version' command gives this: Server version 4.0.1-alpha Protocol version 10 Connection Localhost via UNIX socket UNIX socket /var/lib/mysql/mysql.sock Uptime: 22 hours 22 min 52 sec so, the server hasn't crashed... I am not 100% sure if I am starting mysqld in the correct manner however. The my.cnf for the server is in /var/lib/mysql/my.cnf, which looks like this: [client] port = 3306 host = localhost [safe_mysqld] open-files-limit=8192 socket=/var/lib/mysql/mysql.sock max_allowed_packet=2M Probably this .cnf file is not sufficient, but I hope that somebody might help me in the right direction :) Thnx, Patrik Birgersson --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
