Problem with BLOB data.

Hi, I have a problem with the migration of a table that has a column with BLOB data. The source server is MySQL version: 4.0.16 and the destination server is MySQL version: 5.0.45 I tried with mysqldump and SELECT INTO but when import the data on the destination server, the BLOB data are

restoring backup, problem with BLOB?

Hello List, I am restoring a MySQL backup (about 40MB), and its taking well over 2 hours to restore. the area where its really hanging is when its importing the BLOB There are about 1200 records, totaling about 10mb in size for these blobs. I am running MyISAM, my current memory settings read:

RE: Problem with BLOB Field

] [mailto:[EMAIL PROTECTED]] Sent: 14 August 2002 12:50 To: [EMAIL PROTECTED]; [EMAIL PROTECTED]; [EMAIL PROTECTED]; [EMAIL PROTECTED] Subject: RE: Problem with BLOB Field I would be suspicious that the problem is with ADO or the underlying COM technology. The maximum size of a string in VB is 64K

Re: Problem with BLOB Field

- Hi, I have already posted this query 4-5 days ago but no reply yet so posting 2nd time. Here is the query. Application Used: Visual Basic 6 Database: MySQL 4.0.2 ODBC: MyODBC 3.51.03 I have create a table which has BLOB field in which i want to save a bitmap file. To save

Problem with BLOB Field

Hi, I have already posted this query 4-5 days ago but no reply yet so posting 2nd time. Here is the query. Application Used: Visual Basic 6 Database: MySQL 4.0.2 ODBC: MyODBC 3.51.03 I have create a table which has BLOB field in which i want to save a bitmap file. To save record i create a

RE: Problem with BLOB Field

There was a reply posted last week --- James Frankman [EMAIL PROTECTED] wrote: Blob limit is 64K use MEDIUMBLOB for your column and I got this from http://www.mysql.com/doc/en/Storage_requirements.html TINYBLOB, TINYTEXT L+1 bytes, where L 2^8 BLOB, TEXT L+2 bytes, where L 2^16

Problem in BLOB Field with zips

How we can import a zip file into the blob field ? I can import zip file into mysql but when i export it. The zip files doesnt works. And its size becames smaller. Is there anybody can help me??? - Before posting, please

Re: Problem with BLOB Field

Try ActualSize instead. - Original Message - From: deep kapasi [EMAIL PROTECTED] To: [EMAIL PROTECTED]; [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Tuesday, August 13, 2002 8:33 AM Subject: Problem with BLOB Field Hi, I have already posted this query 4-5 days ago but no reply yet so

Re: Problem in BLOB Field with zips

On Tue, 13 Aug 2002, Aziz Durmaz wrote: How we can import a zip file into the blob field ? I can import zip file into mysql but when i export it. The zip files doesnt works. And its size becames smaller. Aziz, you are not extremely generous in describing what you tried to do and how you

Re: Problem in BLOB Field with zips

What size are the ZIP files? The default BLOB field has a size limit of 64KB. If your ZIP files are larger, they are being clipped. Use MEDIUMBLOB or whatever is most appropriate for your needs. tim. How we can import a zip file into the blob field ? I can import zip file into mysql but

Re: Problem in BLOB Field with zips

Aziz, Tuesday, August 13, 2002, 4:17:35 PM, you wrote: AD How we can import a zip file into the blob field ? AD I can import zip file into mysql but when i export it. The zip files doesnt AD works. And its size becames smaller. AD Is there anybody can help me??? How did you insert and

RE: Problem with BLOB Field

: Tuesday, 13 August 2002 10:03 PM To: [EMAIL PROTECTED]; [EMAIL PROTECTED]; [EMAIL PROTECTED] Subject: Problem with BLOB Field Hi, I have already posted this query 4-5 days ago but no reply yet so posting 2nd time. Here is the query. Application Used: Visual Basic 6 Database: MySQL 4.0.2 ODBC

Re: Problem with BLOB Field

You may use ADO Stream object for retriving and saving BLOB data. deep kapasi [EMAIL PROTECTED] 08/13/02 06:03PM Hi, I have already posted this query 4-5 days ago but no reply yet so posting 2nd time. Here is the query. Application Used: Visual Basic 6 Database: MySQL 4.0.2 ODBC: MyODBC

RE: Problem in BLOB Field with zips

13, 2002 6:19 PM To: Aziz Durmaz; [EMAIL PROTECTED]; [EMAIL PROTECTED] Subject: Re: Problem in BLOB Field with zips What size are the ZIP files? The default BLOB field has a size limit of 64KB. If your ZIP files are larger, they are being clipped. Use MEDIUMBLOB or whatever is most appropriate

Re: Problem with BLOB field

--- Egor Egorov [EMAIL PROTECTED] wrote: deep, Thursday, August 08, 2002, 4:08:22 PM, you wrote: dk It looks like a simple bug but I have spent lots of dk hours try to solved it but not success yet. dk Application: Visual Basic 6.0 dk Database used: MySQL 4.0.1 MySQL 4.0.2 dk ODBC:

Problem with BLOB and JPG files

Hi, I'm using : - Win NT 4.0 SP6 - Apache 1.3 - PHP 4.05 - MySQL 3.23 When I try to upload JPG files, the temporay files on the server are OK. But when I store them into a BLOB field into mySQL, some images (not all) are truncated after some lines. It's like an EOF byte found ... The SQL is:

Problem with BLOB and JPG files

Hi, I'm using : - Win NT 4.0 SP6 - Apache 1.3 - PHP 4.05 - MySQL 3.23 When I try to upload JPG files, the temporay files on the server are OK. But when I store them into a BLOB field into mySQL, some images (not all) are truncated after some lines. It's like an EOF byte found ... The SQL is:

RE: Problem with BLOB and JPG files

Hi, I'm using : - Win NT 4.0 SP6 - Apache 1.3 - PHP 4.05 - MySQL 3.23 When I try to upload JPG files, the temporay files on the server are OK. But when I store them into a BLOB field into mySQL, some images (not all) are truncated after some lines. It's like an EOF byte found ... The

RE: Problem with BLOB and JPG files

At 6:35 PM +0200 9/5/01, Carsten H. Pedersen wrote: Hi, I'm using : - Win NT 4.0 SP6 - Apache 1.3 - PHP 4.05 - MySQL 3.23 When I try to upload JPG files, the temporay files on the server are OK. But when I store them into a BLOB field into mySQL, some images (not all) are

RE: Problem with BLOB and JPG files

-Original Message- From: Paul DuBois [mailto:[EMAIL PROTECTED]] At 6:35 PM +0200 9/5/01, Carsten H. Pedersen wrote: Hi, I'm using : - Win NT 4.0 SP6 - Apache 1.3 - PHP 4.05 - MySQL 3.23 When I try to upload JPG files, the temporay files on the server are OK.

RE: Problem with BLOB and JPG files

At 7:34 PM +0200 9/5/01, Carsten H. Pedersen wrote: -Original Message- From: Paul DuBois [mailto:[EMAIL PROTECTED]] At 6:35 PM +0200 9/5/01, Carsten H. Pedersen wrote: Hi, I'm using : - Win NT 4.0 SP6 - Apache 1.3 - PHP 4.05 - MySQL 3.23 When I try to

Re: problem with blob

I am having exactly the same problem. Does anyone know what is causing this? Thanks Mike jenkins - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list

Re: problem with blob

Hi again. Just thought that I'd repost my message cause I think nobody was checking their mail when I first posted it. Not rying to spam or anything I just really need to figure this out. Thanks, Jay (see post below) At 07:45 AM 2/21/2001 +00-03, Jay Brushett wrote: Hi, I'm new to MySQL

problem with blob

Hi, I'm new to MySQL so please forgive me if this post is very rudimentary. I've created a new database and added all my tables, etc... Everything seems to be fine except for a blob field in one of my tables. I'm using myODBC and ColdFusion 4.0 on Win2000. When I output the content the blob