Have a relative location that is manageable and store the location and name of the file in the dB then get the application logic to use it from there.
I've done something similar and have gone well over a 250K objects so I wouldn't worry about scaling, and that's blobbing not linking. Load data infile doesn't "link" the file, it imports the contents into the dB. Jerry ----- Original Message ----- From: "Barry Hayden" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Tuesday, March 04, 2003 11:28 AM Subject: Loading pictures dynamically into MySql? > Hi, > > I'm quite new to MySql and databases in general (as will > probably be obvious shortly). > > I am working on a very large commercial site right now that will > have to database approx. 500 plus pictures, txt files and other various > things (such as client info). > > Throughout a few tutorials and other various readings I've found > where I can link txt files to the database using LOAD DATA INFILE but > haven't seen anything referring to pictures. Is it possible to > dynamically link pictures to a MySql database? If so, could someone > point me in the right direction? Also, does anyone feel that this kind > of project might be better suited for a different database program like > Access or something like that. I would sure appreciate the help. > > Barry > > > --------------------------------------------------------------------- > Before posting, please check: > http://www.mysql.com/manual.php (the manual) > http://lists.mysql.com/ (the list archive) > > To request this thread, e-mail <[EMAIL PROTECTED]> > To unsubscribe, e-mail <[EMAIL PROTECTED]> > Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php > --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
