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 s
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 m
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 someth
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 fil
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 inst
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
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
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 inst
[EMAIL PROTECTED]>
Cc: <
Sent: Friday, 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 t
; <- disconnect= 1 at blob.cgi line 26.
> -> DESTROY for DBD::mysql::st (DBI::st=HASH(0x81bcd04)~INNER)
> <- DESTROY= undef during global destruction.
> -> DESTROY for DBD::mysql::db (DBI::db=HASH(0x81b34a0)~INNER)
> <- DESTROY= undef during global destructio
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 quote
ruction.
- 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 Smit
at you get.
What is it?
>
>- Original Message -
>From: "Paul DuBois" <[EMAIL PROTECTED]>
>To: "Gerald Clark" <[EMAIL PROTECTED]>; "Kevin Smith"
><[EMAIL PROTECTED]>
>Cc: <[EMAIL PROTECTED]>
>Sent: Friday, February
MAIL 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:
> >The single quotes around $image prevent perl from substituting the value.
> >You are trying to load a file named $imageFN.
> &
ROY for DBD::mysql::db (DBI::db=HASH(0x81b34a0)~INNER)
<- DESTROY= undef during global destruction.
- Original Message -
From: "Gerald Clark" <[EMAIL PROTECTED]>
To: "Kevin Smith" <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>
Sent: Friday, February 01,
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
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
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')
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 Readi
OTECTED]>
Sent: Wednesday, November 21, 2001 2: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: W
- 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
> 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?
>
>
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 valu
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 Milivoj
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_f
> 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);
>
>
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
--
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 pic
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_
Here is a tutorial that might help you.
Go to http://www.weberdev.com. Click on: (Articles and
Tutorials)->(PHP)->(HTTP)->(Uploading files to the server with PHP)
-Original Message-
From: Hesham Anan [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, March 06, 2001 10:54 AM
To: mysql
Subject: loa
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 P
31 matches
Mail list logo