mysql probably does not have search permission on /home/alex.
copy the file to /tmp and see what happens.
Alex Safonov wrote:
Greetings,
just saw a message with an example of inserting a BLOB
value using load_file(). Can't get load_file() to
work:
mysql select
http://www.mysql.com/doc/en/BLOB.html
-Original Message-
From: Roland Perez [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, September 24, 2002 3:35 PM
To: Receipt Notification Requested
Subject: Store pictures in DB
Can I use MySQL to store pictures as part of a record?
Should I
You can store pictures in a BLOB field, but it is generally recommended that
you simply store the filename of the picture.
-Original Message-
From: Roland Perez [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, September 24, 2002 9:35 AM
To: [EMAIL PROTECTED]
Subject: Store pictures in DB
Can
+1
For medical imaging, at least in radiology (PACS), you usually see the
terabytes of images being stored on a NAS somewhere, and the database
itself is actually pretty small just pointing to filenames of where the
pictures are located. This keeps the database small and fast, and lets
you
Can I use MySQL to store pictures as part of a record?
You CAN.
Should I just try to store the name of the picture?
Yes. If you have FTP Access or similiar, I would prefere this!
Some remarks from the manual :
-- Insert a File located locally on MySQL-Serverinto a blob-column
INSERT INTO
+1
For medical imaging, at least in radiology (PACS), you usually see the
terabytes of images being stored on a NAS somewhere, and the database
itself is actually pretty small just pointing to filenames of where the
pictures are located. This keeps the database small and fast, and lets
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Roland Perez wrote:
| Can I use MySQL to store pictures as part of a record?
| Should I just try to store the name of the picture?
Yep but it depends on the size of the pictures. We produce certificates
here and we hold images of engineer signatures