Re: How to insert a binary data size of 4GB into a longblob column.
Martin Evans <[email protected]>
| Newsgroups | gmane.comp.db.mysql.odbc |
|---|---|
| Organization | Easysoft Limited |
| Message-ID | <[email protected]> |
crazyODBC wrote: > I was using unixODBC as the driver manager and mysql ODBC driver to connect > to the mysql server. I am using Linux platform and coding with C++. I had > created a table with a column type of longblob and wish to use ODBC function > call to insert a 4GB of data into the mysql database. At first, I got error > saying that the data size is over the limit of max_allowed_packet size, so I > changed the max_allowed_packet to around 1GB (that is the max > max_allowed_packet variable can take). Then I start to sent a 1GB data to > the mysql database. It will complaint about "Out of memory (Needed > 500000048 bytes)". Seems like I could only sent max of 500 MB of data, > otherwise the mysql server will complaint about the above out of memory > problem. Not sure how to get around this problem. Could any help, Thanks > in advance. What ODBC call are you using to insert the data? I think you need to insert it in small chunks using SQLPutData. Martin -- MySQL ODBC Mailing List For list archives: http://lists.mysql.com/myodbc To unsubscribe: http://lists.mysql.com/[email protected]