Olav Wirtz writes:
> LOAD DATA LOCAL INFILE "txt_name.txt" INTO TABLE table_name; " > > But it does not tell me where I have to save this txt file. I tried it in > several directories, but MySQL cannot find the file. Did you by any chance specify an incorrect path to the file in the query? Don't rely on mysql's current directory to be something specific, but give the full path to the file instead. //C -- Carl Troein - Círdan / Istari-PixelMagic - UIN 16353280 [EMAIL PROTECTED] | http://pixelmagic.dyndns.org/~cirdan/ Amiga user since '89, and damned proud of it too. --------------------------------------------------------------------- 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