How to insert a binary data size of 4GB into a longblob column.

[crazyODBC]

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.

 

[mrdenny]

This is a Microsoft SQL forum. You'll want to post that in the MySQL forum forum436.

Denny
MCSA (2003) / MCDBA (SQL 2000)
MCTS (SQL 2005 / Microsoft Windows SharePoint Services 3.0: Configuration / Microsoft Office SharePoint Server 2007: Configuration)
MCITP Database Administrator (SQL 2005) / Database Developer (SQL 2005)

--Anything is possible. All it takes is a little research. (Me)

http://www.mrdenny.com

 

[SQLDenis]

hey princess, wrong forum, this is MS SQL server not MySQL

you need forum

http://www.tek-tips.com/threadminder.cfm?pid=436

Denis The SQL Menace
--------------------
SQL Server Code,Tips and Tricks, Performance Tuning
SQLBlog.com
Google Interview Questions

 

[ESquared]

This is the SQL Server forum. The folks over in the MySQL forum could probably help you better!

 

[ESquared]

Hilarious.