You wrote: >Suppose I wanted to upload a lot of files (1000 or so) to MySQL... sort of >like FTP-ing files to another server's directory... Is there a way to get >them all into MySQL like that? Uploading to a database seems much different >than uploading to a server... >Next, suppose I just FTP-ed a bunch of files to a directory on my server, >and then I wanted to catalog all the links in a MySQL database table... Is >there a way to get all those links into the database without having to >manually insert them one at a time? You're going to need some script, in which case you've got one of three routes: 1. LOAD DATA mysql command, (see manual section 3.2.3 for details). 2. A program using one of the API's, (I'm doing something vaguely similar to what you want, and I'm using a C program). 3. PHP and a web page, (i.e. "click this button to upload these files")?
Regards Robert Cross, EDS UK Ltd. (Disregard below it's just to get past the spam filter). "Oh great MySQL database, that contains the myriad tables of data. Who knows what wonders my sql queries may bring forth?" Disclaimer 1: Everything above this line has nothing to do with my employer, their contribution follows.... * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * This message is confidential. It may also be privileged or protected by other legal rules. It does not constitute an offer or acceptance of an offer, nor shall it form any part of a legally binding contract. If you have received this communication in error, please let us know by reply then destroy it. You should not use, print, copy the message or disclose its contents to anyone. E-mail is subject to possible data corruption, is not secure, and its content does not necessarily represent the opinion of this Company. No representation or warranty is made as to the accuracy or completeness of the information and no liability can be accepted for any loss arising from its use. This e-mail and any attachments are not guaranteed to be free from so-called computer viruses and it is recommended that you check for such viruses before down-loading it to your computer equipment. This Company has no control over other websites to which there may be hypertext links and no liability can be accepted in relation to those sites. Scottish & Newcastle plc Registered in Scotland, Registered Number 16288 Registered Office: 33, Ellersly Road, Edinburgh, EH12 6HX * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * --------------------------------------------------------------------- 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