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

EMAIL PROTECTED] [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 stri

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 fil

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: MyO

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

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 al

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 <

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 AD

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.

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 >> >>

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

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 a

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 .

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: $reqS

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: $reqS

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 co