I agree with Walter, a filesystem is far better suited for this. That said, mysql does have the ability to do what you are saying, you would just store it as a binary blob which is well documented and quite easy to use.
See: http://dev.mysql.com/doc/refman/5.0/en/blob.html Colin On January 30, 2010 05:01:54 am Vikram A wrote: > Dear Sir, > > Let me explain what i understood, > > 1. I have to create a shareable folder among the network. > 2. The image files has to be kept at share machine > 3. Then the path (share machine) of the file has to be stored in the DB > 4. When we want it has to be taken from the share > > 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. > > Please share your knowledge > > Thank you > > > > > > > ________________________________ > From: Walter Heck <wal...@openquery.com> > To: Vikram A <vikkiatb...@yahoo.in> > Cc: MY SQL Mailing list <mysql@lists.mysql.com> > 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 <vikkiatb...@yahoo.in> 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? > > cheers, > > Walter Heck > Engineer @ Open Query (http://openquery.com) > -- Q: What's the difference between an Irish wedding and an Irish wake? A: One less drunk. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql?unsub=arch...@jab.org
