> What I am trying to do is to enter a genome sequence which has around
> 1750000 characters. the file size is about 1.5MB which is well within
> the longblob size. I am using python to enter the sequence from a file
> to the database and the while i am running the python program ,the
>connection to the db is lost. So it takes in only around 103500
>characters.
To determine if the problem is with the server you could try inserting
from the command line client:
INSERT INTO your_table (longblob_col) VALUES
(LOAD_FILE('/path/to/yourfile'));
I just tried this and I could only get it to work if the file was in the
mysql data directory and had world readable permissions, but I could
successfully insert 5 MB files into long blobs after I increased
max_allowed_packet.
If that works then the problem is probably with your python client.
best,
Jeremy
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
