Seth Redmond [EMAIL PROTECTED] wrote:
sorry, should have said - I get the record created, but with a null
value in the blob - as you would for a file larger than the
max_allowed. but I've checked numerous times (and have gone up to
longblob) and still can't load above around 1mb.
I should
sorry, should have said - I get the record created, but with a null
value in the blob - as you would for a file larger than the
max_allowed. but I've checked numerous times (and have gone up to
longblob) and still can't load above around 1mb.
I should also mention that it's running on the same
Seth Redmond [EMAIL PROTECTED] wrote:
I've been having a few problems loading blobs via the LOAD_FILE function
I've tried things along the lines of:
UPDATE table SET binaryRecord=LOAD_FILE(/Users/shared/filename.mov)
where refNo=1;
It only seems to happen when loading something over
I've been having a few problems loading blobs via the LOAD_FILE function
I've tried things along the lines of:
UPDATE table SET binaryRecord=LOAD_FILE(/Users/shared/filename.mov)
where refNo=1;
It only seems to happen when loading something over 1-1.5mb, as I've
been able to load smaller
At 4:22 +0800 2/7/02, yue cheng wrote:
Hi,
Now I am puzzled by the filepath,Load_file, I install
MySQL in Windows98, the file which i want to insert to
table is c:\P1.bmp
when I run load_file in mysql command line,it succeeds
mysql insert into blobtable (load_file(/P1.bmp))
but i don't know why
First off, you trying to insert the image into the database or just its
path?
-Original Message-
From: yue cheng [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, February 06, 2002 2:23 PM
To: [EMAIL PROTECTED]
Subject: Load_File issue
Hi,
Now I am puzzled by the filepath,Load_file, I
At 4:22 +0800 2/7/02, yue cheng wrote:
Hi,
Now I am puzzled by the filepath,Load_file, I install
MySQL in Windows98, the file which i want to insert to
table is c:\P1.bmp
when I run load_file in mysql command line,it succeeds
mysql insert into blobtable (load_file(/P1.bmp))
but i don't know why
After reading some other posts on inserting a image into a blob field, I
tried using DBI to insert and the following does not work...
I've double-checked the path and it is correct.
$imageFN = '/var/www/htdocs/corporate/images/homenew.jpg';
$SQL = UPDATE banners SET image=load_file('$imageFN')
The single quotes around $image prevent perl from substituting the value.
You are trying to load a file named $imageFN.
$SQL = UPDATE banners SET image=load_file(\$imageFN\) where id=1;
Kevin Smith wrote:
After reading some other posts on inserting a image into a blob field, I
tried using DBI
At 11:32 -0600 2/1/02, Gerald Clark wrote:
The single quotes around $image prevent perl from substituting the value.
You are trying to load a file named $imageFN.
$SQL = UPDATE banners SET image=load_file(\$imageFN\) where id=1;
But the single quotes are within a double-quoted string. So
.
- Original Message -
From: Gerald Clark [EMAIL PROTECTED]
To: Kevin Smith [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Sent: Friday, February 01, 2002 5:32 PM
Subject: Re: LOAD_FILE over SMB filesystems
The single quotes around $image prevent perl from substituting the value.
You are trying
Yes, it definitely is... I'm running Apache 1.3.22 on Linux RedHat 7.1 and
MySQL 3.23.47.
- Original Message -
From: Paul DuBois [EMAIL PROTECTED]
To: Gerald Clark [EMAIL PROTECTED]; Kevin Smith
[EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Sent: Friday, February 01, 2002 5:37 PM
Subject: Re
is it?
- Original Message -
From: Paul DuBois [EMAIL PROTECTED]
To: Gerald Clark [EMAIL PROTECTED]; Kevin Smith
[EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Sent: Friday, February 01, 2002 5:37 PM
Subject: Re: LOAD_FILE over SMB filesystems
At 11:32 -0600 2/1/02, Gerald Clark wrote
]
Sent: Friday, February 01, 2002 5:43 PM
Subject: Re: LOAD_FILE over SMB filesystems
At 17:41 + 2/1/02, Kevin Smith wrote:
Yes, it definitely is... I'm running Apache 1.3.22 on Linux RedHat 7.1
and
MySQL 3.23.47.
Does the script connect to the MySQL server using a MySQL account
that has
Paul DuBois wrote:
At 11:32 -0600 2/1/02, Gerald Clark wrote:
The single quotes around $image prevent perl from substituting the
value.
You are trying to load a file named $imageFN.
$SQL = UPDATE banners SET image=load_file(\$imageFN\) where id=1;
But the single quotes are within a
destruction.
- Original Message -
From: Paul DuBois [EMAIL PROTECTED]
To: Kevin Smith [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Sent: Friday, February 01, 2002 5:43 PM
Subject: Re: LOAD_FILE over SMB filesystems
At 17:41 + 2/1/02, Kevin Smith wrote:
Yes, it definitely is... I'm running
, February 01, 2002 5:57 PM
Subject: Re: LOAD_FILE over SMB filesystems
At 17:47 + 2/1/02, Kevin Smith wrote:
I don't get an error message... I'm actually running the script from the
shell prompt, so I'm totally mystified about why it's not working.
Umm, actually it is working, according
On Wed, 2002-01-23 at 07:42, Egor Egorov wrote:
Panos,
Tuesday, January 22, 2002, 5:42:20 PM, you wrote:
PM I have some problems loading files into blobs when the file
PM resides on a network filesystem e.g. SAMBA. I use mysqld
PM 3.23.43-nt.
PM e.g.
PM UPDATE Reading SET
I have been trying to load the textual contents of a file from my
hard drive
space into a field (Description) of my mySQL table (Software) using the
follwing query. The query runs succfessfully
How do you know that it's successful? What success/error codes
(if any) are returned?
cut
- Original Message -
From: Carsten H. Pedersen [EMAIL PROTECTED]
To: Sharaaz Khan [EMAIL PROTECTED]; [EMAIL PROTECTED]
Sent: Wednesday, November 21, 2001 1:52 PM
Subject: RE: LOAD_FILE does not work
I have been trying to load the textual contents of a file from my
hard drive
:08 PM
Subject: Re: LOAD_FILE does not work
- Original Message -
From: Carsten H. Pedersen [EMAIL PROTECTED]
To: Sharaaz Khan [EMAIL PROTECTED]; [EMAIL PROTECTED]
Sent: Wednesday, November 21, 2001 1:52 PM
Subject: RE: LOAD_FILE does not work
I have been trying to load
Does the user mysql have search and read permissions to the directroy
and file you are trying to load?
Venugopal Allavatam wrote:
Hi All!
I am sorry that I posted that message with a syntactical error. but
what i meant to write was this..
insert into table_name(field_name1,data_file)
Are you trying to load the contents of a file with an INSERT statement? If
so, you can't. The values MUST be constants.
What are your really trying to do?
-Original Message-
From: Venugopal Allavatam [mailto:[EMAIL PROTECTED]]
Sent: Monday, November 12, 2001 12:26 PM
To: Sinisa
oops...I'm wrong...you can load that way.
-Original Message-
From: Rick Emery
Sent: Monday, November 12, 2001 12:56 PM
To: [EMAIL PROTECTED]
Subject: RE: load_file problem
Are you trying to load the contents of a file with an INSERT statement? If
so, you can't. The values MUST
Hi All!
I am a newbie at mySQL. I need to implement a database which has the
capability to store some *.dat files. hence i have already implemented
a table using:
create table table_name (field_name1 int unsigned auto_increment
primary key not null, data_file longblob not null);
I then
See MySQL Manual section 6.4.1
SELECT INTO OUTFILE
database - to satisfy mailer-daemon
-Original Message-
From: Jason Kwok [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, September 19, 2001 10:21 PM
To: [EMAIL PROTECTED]
Subject: Load_File
Load_File is used to read a picture (or
The manual said if you want to write a BLOB data into
file, you should use INTO DUMPFILE,
But that still doen't work.
I got a Dumpfile with just 1 byte.
There is a BLOB data in my table.
What is the problem?
best regards
hxia
See MySQL Manual section 6.4.1
SELECT INTO OUTFILE
--
On Mon, 26 Mar 2001, Maros Klempa wrote:
Hi,
I have two servers with MySQL 3.23.24-beta. One as master and one as slave.
Replication between this two servers work fine. Now I want store pictures
to table. On master server I use command
INSERT INTO PICTURES (ID, PICT) VALUES (1, LOAD_FILE(
Yes, you have missed something. Somewhere into chapter 7 of the manual,
can't remember exactly where off the top of my head, it talks about adding
backslashes. It is to do with inserting text. It is required for special
characters.
- Original Message -
From: "Richard Vibert" [EMAIL
29 matches
Mail list logo