-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 Ahmed S K Anis wrote:
HI,You need to set the max_allowed_packet configuration variable for your MySQL server large enough to handle the largest file you want to send as a single packet. If you are sending large files, you will most likely want to use MySQL-4.0 or newer as well, as the protocol in MySQL-4.0 handles larger packets than MySQL-3.23 does.
Thanks all for the suggestions given for load data... It indeed helped
me a lot.
Right now i am using J/connector version 3 .
Load data local ....works fine !!!! with version 3.
I hit a new problem. It works fine when there are below 20000 records
in the file. When i tried wiht 4,00,000 records inthe file it gave an
exception.
" packet for query is too large (5242884 > 5241856)"
com.mysql.jdbc.Packettoobigexception
Any thoughts on this.
Anis
-Mark
- -- MySQL 2003 Users Conference -> http://www.mysql.com/events/uc2003/
For technical support contracts, visit https://order.mysql.com/?ref=mmma
__ ___ ___ ____ __
/ |/ /_ __/ __/ __ \/ / Mark Matthews <[EMAIL PROTECTED]>
/ /|_/ / // /\ \/ /_/ / /__ MySQL AB, Full-Time Developer - JDBC/Java
/_/ /_/\_, /___/\___\_\___/ Flossmoor (Chicago), IL USA
<___/ www.mysql.com
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.1.90 (MingW32)
Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org
iD8DBQE+S6UytvXNTca6JD8RAk14AJ4xXGKDunjkHXnfZLOHJtPJfucK1wCdFEZ/
yTQL8+T/K5ce4pHXLtgx1is=
=ihg1
-----END PGP SIGNATURE-----
---------------------------------------------------------------------
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
