>>>>> "wojtek" == wojtek <[EMAIL PROTECTED]> writes: wojtek> Ladies and Gentlemen, wojtek> I have a question regarding inserting binary files into mySQL (midtext). wojtek> I am having problems inserting files bigger then 1MB , even with wojtek> max_allowed_packet set to 5MB. Database gets corrupted on every wojtek> attempt above 1MB?!?!?. Mysql version is 3.21.33b running on wojtek> Ultra-5, Solaris 2.6 ,128MB RAM. wojtek> Is it mySQL limitation or maybe I am missing another parameter to be set wojtek> correctly? BTW: I am talking to mySQL from PHP3.05. wojtek> Regards, Hi! MySQL 3.21.33 should be able to handle blobs up to 24M. How do you insert the blob. Exactly what happens when you insert the blob? Do you get any error when inserting the blob ? What error do you get from isamchk? Please include in the response the output from mysqladmin flush-tables ; isamchk database/table_name (after you have inserted a block in a correct database) You can also easily test big blobs with the script 'tests/big_record.pl' Just change rows=20 to rows=500 to test this with blobs up to 5M Regards, Monty ----------------------------------------------------------- Send a mail to [EMAIL PROTECTED] with unsubscribe mysql [EMAIL PROTECTED] in the body of the message to unsubscribe from this list.
