You can make a script that formats all the file names into a text file and use mysqlimport or "load data infile" to import them into the database. Or you can use a scripting language like perl to get all the file names and insert them into the database. hope that helps. ryan ----- Original Message ----- From: "David" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Monday, April 09, 2001 7:49 PM Subject: Best way to add over 5,000 mp3 file names to database > I have a hard drive dedicated to mp3 files that are stored in the > following format: /mp3/artist/album/song1.mp3. What is the best way to > add these file names to a database. I have been adding a few via a web > interface but can only do one at a time which is not going to work. I > also tried just listing the files in each directory and redirecting > output to a text file and loading the database from the text file. > There has to be a better way. > > Running Linux with latest MySQL rpm > > > > --------------------------------------------------------------------- > 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