ay, July 17, 2006 11:21 PM
Subject: Re: load-file() doesn't work [SOLVED]
Hi Fleet
[EMAIL PROTECTED] wrote:
SHORT SYNOPSIS:
The statement
INSERT INTO table (blob_column) VALUES
(load_file('/home/somebody/image.jpg'));
Produces no error; but fails to load the image file.
SOLUT
On Mon, 17 Jul 2006, Marc Alff wrote:
> Just to check, is the /home partition actually mounted on the server,
> and at the same place ?
>
> In other words, does /home/fleet/image.jpg exists :
> - when seen from the host running mysql
> - when seen from the host running mysqld
In answer to the abo
Hi Fleet
[EMAIL PROTECTED] wrote:
> SHORT SYNOPSIS:
> The statement
> INSERT INTO table (blob_column) VALUES
> (load_file('/home/somebody/image.jpg'));
>
> Produces no error; but fails to load the image file.
>
> SOLUTION:
> The image file (or other binary file, I assume) MUST reside in / or /tm
SHORT SYNOPSIS:
The statement
INSERT INTO table (blob_column) VALUES
(load_file('/home/somebody/image.jpg'));
Produces no error; but fails to load the image file.
SOLUTION:
The image file (or other binary file, I assume) MUST reside in / or /tmp,
ie /image.jpg or /tmp/image.jpg. (At least in MySQ
Fleet, I'd also humbly suggest that the version you're using is VERY
old and you should update to at least the latest 3.23 (3.23.58 I
think), or 4.x, or maybe even 5.0 (production since last Fall).
Untold numbers of bugs fixed since 3.23.36.
Dan
On 7/17/06, Chris <[EMAIL PROTECTED]> wrote:
[EM
[EMAIL PROTECTED] wrote:
I'm using MySQL 3.23.36 on RH 7.1. I've created a table photos (in
database album) with the following colums:
ID NUM AUTO_INCREMENT PRIMARY KEY
IMAGE MEDIUMBLOB
I'm running mysql from the command line:
mysql -u root
'root' has all privileges.
The file I'm trying to lo
I'm using MySQL 3.23.36 on RH 7.1. I've created a table photos (in
database album) with the following colums:
ID NUM AUTO_INCREMENT PRIMARY KEY
IMAGE MEDIUMBLOB
I'm running mysql from the command line:
mysql -u root
'root' has all privileges.
The file I'm trying to load is /home/fleet/image.jpg
Andreas,
- Original Message -
From: "Andreas Ahlenstorf" <[EMAIL PROTECTED]>
Newsgroups: mailing.database.myodbc
Sent: Friday, March 18, 2005 11:47 AM
Subject: Re: Problem: Slow "LOAD FILE" performance with innodb
Heikki Tuuri schrieb:
Creating the indexes
Heikki Tuuri schrieb:
> Creating the indexes after the import will only slow down the operation.
> MySQL recreates the whole table at CREATE INDEX.
That's new to me, but good to know (always this urban legends...).
Does that only apply to InnoDB or to MyISAM too?
Regards,
A.
--
MySQL General
ay, March 18, 2005 1:00 AM
Subject: Re: Problem: Slow "LOAD FILE" performance with innodb
My first guess is the indexes. Maybe create them after the import. It will
nonetheless take a bit of time!
--Original Message--
From: Jarle Aase
To: MySQL list
Sent: Mar 17, 2005 11:53
Jarle Aase schrieb:
> Is there a way to boost the performance? The database is idle, and while
> importing, performance is the key priority (record-locking,
> transaction-rollbacks and file-integrety/crash-recovery are not required
> until the data are imported).
- Disable the foreign key checks
My first guess is the indexes. Maybe create them after the import. It will
nonetheless take a bit of time!
--Original Message--
From: Jarle Aase
To: MySQL list
Sent: Mar 17, 2005 11:53 PM
Subject: Problem: Slow "LOAD FILE" performance with innodb
Hi list,
I'm trying to i
Hi list,
I'm trying to import some data into a MySQL database. The data-file is
5.5G, and consist of about 132 million rows. The machine is a P4 3GHz
with 1G RAM and a single 250 GB ATA-disk for data. The operating system
is Debian GNU Linux "testing" with kernel 2.6.8 with hyperthreading
support.
ement field? Do I include a first field with \N? If
the MySQL table has 20 columns with the first being the
autoincrement,
can my load file be only 19 columns?
Thanks.
Randy
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[
That should work just fine (although you should end the line with ; and
not l)
Regards,
Mike Hillyer
www.vbmysql.com
-Original Message-
From: Anthony Ward [mailto:[EMAIL PROTECTED]
Sent: Thursday, June 05, 2003 3:54 AM
To: [EMAIL PROTECTED]
Subject: load file
Hi,
I have a a text
Hi,
I have a a text file delimited with | and I don't how to load the data into
a table and say delimited by '|'
I think it is this:
LOAD DATA INFILE 'C:\data.txt' INTO TABLE table2 FIELDS TERMINATED BY '|'l
Any clarification would help.
Anthony
--
MySQL General Mailing List
For list archiv
Jim,
Saturday, April 13, 2002, 2:00:55 AM, you wrote:
JP> Is it possible to load a file from a remote host as data type blob? This
JP> needs to be done from within the C API.
Only using MySQL - no, with other programs/languages yes ...
--
For technical support contracts, goto https://order.
keywords: sql, query
Is it possible to load a file from a remote host as data type blob? This
needs to be done from within the C API.
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http:/
Is this a true export? Because I've never had garbage lines in my files.
Dave
On Mon, Mar 04, 2002 at 10:33:14AM -0600, Paul DuBois wrote:
> At 10:58 -0500 3/4/02, Richard Bolen wrote:
> >I'm exporting data from Oracle and importing it into MySQL. The
> >problem is Oracle puts garbage lines at
I'm exporting data from Oracle and importing it into MySQL. The problem is Oracle
puts garbage lines at the end of it's output files. Lines like "300 rows selected"
and "input truncated to 9 chars" as well as empty lines. When MySQL loads these
files, I'm getting rows inserted for the empty
20 matches
Mail list logo
