Vikram A wrote:
Is it So? then i may have the following, when ever i want the image of a i
need look for the share machine! If it is not available it may cause some
difficulties.
1) NFS sharing a file (any file) is better suited for this task.
2) The DB should only hold the file path
Please share your knowledge
>
> Thank you
>
>
>
>
>
>
>
> From: Walter Heck
> To: Vikram A
> Cc: MY SQL Mailing list
> Sent: Sat, 30 January, 2010 3:16:11 PM
> Subject: Re: Image Store @ My SQL
>
> On Sat, Jan 30, 2010 at 19:03, Vikram A wrote:
> >
January, 2010 3:16:11 PM
Subject: Re: Image Store @ My SQL
On Sat, Jan 30, 2010 at 19:03, Vikram A wrote:
> I am not clear with your answer, can you please explain it?
Well, MySQL (as most databases) is not really suited for storing
images. If you create a networked storage that you can sh
Bad idea. Sotring images is what a file system is for. Create an NFS
or other networked storage and store your images there. I don't see
the problem?
good luck,
Walter Heck
Engineer @ Open Query (http://openquery.com)
On Sat, Jan 30, 2010 at 18:54, Vikram A wrote:
> Hi,
>
> I am using MYSQL wit
On Sat, Jan 30, 2010 at 19:03, Vikram A wrote:
> I am not clear with your answer, can you please explain it?
Well, MySQL (as most databases) is not really suited for storing
images. If you create a networked storage that you can share between
both locations, that would solve your problem, right?
Dear Walter Heck,
I am happy to receive immediate response from you.
I am not clear with your answer, can you please explain it?
Thank you
From: Walter Heck
To: Vikram A
Cc: mysql@lists.mysql.com
Sent: Sat, 30 January, 2010 2:29:43 PM
Subject: Re: Image
Hello.
>From my experience in most cases it is recommended to store images
in files.
ESV Media GmbH wrote:
> Hey,
>
> we´ve large amount of Images ( nearly 2 GB ).
> And they will increase, cause or Editors will submit several articles a
> day where they´re allowed to upload
> some ne
Hi Marco!
I had a similar problem and was advised that the native filesystem is faster
than doing lookups and some sort of rendering. So storing the link in the
db will do it, and then just have the images at the pointed-to location.
Cheers!
-Warren
- Original Message -
From: "ES
Hi,
you have to escape your binary data; check mysql_real_escape_string()
function in the manual and the archives. This is a frequently asked
question.
Thomas Spahni
On 14 Jul 2003, Sreesekhar Palaparthy wrote:
> Hi,
> How do i insert binary data into a BLOB field??? Like , if i
> have
I have seen a solution from a book how to display image queryed by php from db
step 1. at first like you ,create a php using Header("Content-type: image/gif")
to display the mesage queried from my sql. This displays the image .for example this
file named "image.php?imageID = ???"
step 2 . in p
Hey,
> 1.I have to store some images in the db. Each image size is around
800kb
> to
> 900kb(almost 1 mb). Will it affect the performance. I am using
mediumblob
> for this.
I'm not sure about this as I've never really tried, but my intuition
tells me: no, it won't affect performance (noticeably
William,
Friday, July 12, 2002, 12:45:02 AM, you wrote:
WM> I am new to MySQL and I was trying to find out how to setup a record
WM> with a datatype as a image jpg etc...
Take a look at BLOB column type:
http://www.mysql.com/doc/B/L/BLOB.html
--
For technical support contract
William Miller <[EMAIL PROTECTED]> wrote:
> I am new to MySQL and I was trying to find out how to setup a record
> with a datatype as a image jpg etc...
I have recently done just that. Here is my table structure:
CREATE TABLE IF NOT EXISTS Item_binary (
entry int(11) NOT NULL,
vidx s
> How can i insert image in a database.
<>
(The MySQL Manual, section 7.1.1)
Cheers,
--
,
M A R I O data miner, LIACC, room 221 tel 351+226078830, ext 121
A M A D O Rua Campo Alegre, 823 fax 351+226003654
A L V E S P-4150 PORTO, Portugalmob 351+939354002
---
Date |Mon, 27 Aug 2001 15:31:26 -0700
>From |John Meyer <[EMAIL PROTECTED]>
Hello!
JM> At 09:15 AM 8/28/01 +1200, you wrote:
>>Hi there,
>>
>>I treat image data type as text, does anyone know how to insert an image
>>into the table?
>>
JM> the image data type is actually a BLOB, not text. Usua
At 09:15 AM 8/28/01 +1200, you wrote:
>Hi there,
>
>I treat image data type as text, does anyone know how to insert an image
>into the table?
>
the image data type is actually a BLOB, not text. Usually, it's more
efficent to have the field be text, and just store the path to the image
(C:\my\p
Read the archives of this list.
P
On Fri, 30 Mar 2001, Sheikh wrote:
> Respected Sir
> i want to know how i store a image in mysql.i sue perl for scripting on linux.
> please help me
> thanks
> allah hafiz
>
>
-
Before post
s) in tables with fixed widths (i.e., no variable-length columns).
- Original Message -
From: "WCBaker" <[EMAIL PROTECTED]>
To: "MySQL" <[EMAIL PROTECTED]>
Sent: Friday, February 23, 2001 11:07 AM
Subject: generic question re. image blobs in dbs
> Hi!
>
&
]>
To: "MySQL" <[EMAIL PROTECTED]>
Sent: Friday, February 23, 2001 12:07 PM
Subject: generic question re. image blobs in dbs
> Hi!
>
> There is a consensus that blobs containing image files like .jpgs, .gifs,
> etc. might better be stored just as links in the datab
Hi!
There is a consensus that blobs containing image files like .jpgs, .gifs,
etc. might better be stored just as links in the database, with the actual
files in a directory pointed to by the database links. Forgive my
ignorance, but can someone explain a few of the more obvious reasons why
t
20 matches
Mail list logo
