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
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:
] [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
-
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
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
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
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
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
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
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
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
: 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
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
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
--- 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:
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:
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:
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
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
-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.
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
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
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
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
24 matches
Mail list logo