Herbert,
> Using MySQL, I have a problem where I am attempting to upload a 16.4MB
file
> into a BLOB field, but the insert fails with a
> ERROR 1030: Got error 139 from table handler
BLOB can store data up to 64 KB only. Use MEDIUMBLOB (up to 16 MB) or
LONGBLOB (up to 4 GB).
For MEDIUMBLOB, be aware that the default communication buffer size is 1
MB only. To increase it, put
set-variable = max_allowed_packet=16M
in your my.cnf / my.ini file and restart the MySQL server.
For LONGBLOB, be aware that the communication buffer can only be set to
16 MB maximum. INSERTing data bigger than 16 MB means you will have to
use UPDATE to "insert" the data in pieces.
Regards,
--
Stefan Hinz <[EMAIL PROTECTED]>
Geschäftsführer / CEO iConnect GmbH <http://iConnect.de>
Heesestr. 6, 12169 Berlin (Germany)
Tel: +49 30 7970948-0 Fax: +49 30 7970948-3
- Original Message -
From: "Herbert Kunzmann" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Saturday, January 11, 2003 9:03 AM
Subject: MySQL LOAD_FILE problems
>
> Using MySQL, I have a problem where I am attempting to upload a 16.4MB
file
> into a BLOB field, but the insert fails with a
>
> ERROR 1030: Got error 139 from table handler
>
> and after trying again I get
>
> ERROR 1062: Duplicate entry 'bla' for key 1
>
> BUT the entry was never made. I need to repair the table in order to
> continue on.
>
> Can anyone give me a hint on what to do ? I remain somewhat lost...
>
>
>
>
> -
> 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
>
-
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
