HI Thomas, Thanks for the reply. Well actually I don't need to search the content of the blob data stored in mysql. I'm just going to create a description w/ a couple of text box that describes the file uploaded.
Regards, Delz ----- Original Message ----- From: "Thomas Spahni" <[EMAIL PROTECTED]> To: "delz" <[EMAIL PROTECTED]> Cc: <[EMAIL PROTECTED]> Sent: Friday, April 04, 2003 6:34 PM Subject: Re: Blobbing data on MySQL > Delz, > > what's the reason to put *.doc into a database? Format of *doc is a PITA > and you can't search it. > > Store the path to the file instead along with a copy of it's content in > plain ASCII and run a fulltext index on that. Have a look at wvWare to do > the conversion. > > Thomas Spahni > > > On Fri, 4 Apr 2003, delz wrote: > > > Hi All, > > > > Good day !!! > > > > I'm trying to setup up a mysql server that will store scanned documents > > (.doc, gif, jpeg, etc......) and will try to achieve this by blobbing data > > into the mysql server. I find this to be very useful for archiving old piles > > of paper and scanning them before they worn out. I also need to create a > > database for it of course, that will store the scanned documents into the > > mysql server. This of course needs a lot of disk space on the hard drive of > > the server specially if you have tons of documents to scan. Blobbing data > > into the mysql server will obviously consume lots of disk space and if it > > turns to be that way, I need another hard disk to store the blob data. Using > > the rpms to install mysql the path where the database are installed is at > > /var/lib/mysql, if I install it via tarball I would install it at > > /usr/local/mysql, my question is how do I make a path for my blob data into > > another hard disk in case the primary hard disk gets full so that the data > > will be saved on another hard drive. I would want to achieve this kind of > > setup for me to have more options rather than setting up another server to > > store the data. I would appreciate if someone could help me on this. > > > > Regards, > > > > Delz > > > > > > > > > > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] > > > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
