Mailing List
Home
Forum Home
MySQL General - General MySQL discussion
MySQL++ - Programming with the C++ API to MySQL
MaxDB - Everything about MaxDB, formerly known as SAP DB
ODBC - ODBC with the MySQL Connector/ODBC driver
MySQL on Win32 - Runing MySQL on Windows 9x/Me/NT/2000/XP
Java Help - Mostly related to the MySQL Connector/J driver
Perl - Perl support for MySQL with DBI and DBD::mysql
GUI - MySQL GUI Tools
Announcement
Subjects
• Subject: mysql openssl Question
• ERROR 1045: Access denied for user: 'root@localhost ' (Using
password: NO)
• Update one field with more fields from another table
• Subject: Getting Identity after INSERT
• ERROR 2002: Can 't connect to local MySQL server through socket
• mysql test 4 1 fails with the gis test
• Subject: MySQL Cluster Software
• Downgrade Mysql from 4 to 3 23
• Mysql 4 0 Oracle Stored Procedure Trigger Conversion
• Can 't access mysql after kernel upgrade
• Executing MySQL Commands From Within C Program
• Comparing and writing out BLOBS
• Subject: Re: Preventing Duplicate Entries
• FULLTEXT query format question
• Strange behavior, Table Level Permission
• Does the binary log enabling affect the MySQL performances?
• mysql:it 's a db not a dbms how it 's possible?!
• mysql have same function mthod as Oracle decode()
 
How to insert a binary data size of 4GB into a longblob column.

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

2007-06-07       - By crazyODBC

 Back
Reply:     1     2     3     4  


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.  
--
View this message in context: http://www.nabble.com/How-to-insert-a-binary-data
-size-of-4GB-into-a-longblob-column.-tf3885758.html#a11014268
Sent from the MySQL - ODBC mailing list archive at Nabble.com.


--
MySQL ODBC Mailing List
For list archives: http://lists.mysql.com/myodbc
To unsubscribe:    http://lists.mysql.com/myodbc?unsub=mysql@(protected)