Hmmm, your "LINES TERMINATED BY '/r/n';" should be:
"LINES TERMINATED BY '\r\n';" if the abc.txt file was generated on windows. If it was made on *nix/linux, it should be: LINES TERMINATED BY '\n'; -- Later Mogens Melander +45 40 85 71 38 +66 870 133 224 On Thu, April 12, 2007 09:58, Thufir wrote: > I'm at total loss. apparently, error 13 relates to file permissions? > what > could possibly be preventing the import? > > <http://paste.husk.org/8073> for: > > [EMAIL PROTECTED] ~]$ > [EMAIL PROTECTED] ~]$ ll /tmp/abc.txt > -rw-r--r-- 1 thufir thufir 33 Apr 12 06:59 /tmp/abc.txt > [EMAIL PROTECTED] ~]$ cat /tmp/abc.txt > A1, B1, C1 > A2, B2, C2 > A3, B3, C3 > [EMAIL PROTECTED] ~]$ mysql -u root > Welcome to the MySQL monitor. Commands end with ; or \g. > Your MySQL connection id is 5 to server version: 5.0.27 > > Type 'help;' or '\h' for help. Type '\c' to clear the buffer. > > mysql> show databases; > +--------------------+ > | Database | > +--------------------+ > | information_schema | > | alpha | > | bravo | > | charlie | > | delta | > | mysql | > | test | > +--------------------+ > 7 rows in set (0.09 sec) > > mysql> use delta; > Reading table information for completion of table and column names > You can turn off this feature to get a quicker startup with -A > > Database changed > mysql> show tables; > +-----------------+ > | Tables_in_delta | > +-----------------+ > | abc | > +-----------------+ > 1 row in set (0.00 sec) > > mysql> describe abc; > +-------+------+------+-----+---------+-------+ > | Field | Type | Null | Key | Default | Extra | > +-------+------+------+-----+---------+-------+ > | a | text | NO | | | | > | b | text | NO | | | | > | c | text | NO | | | | > +-------+------+------+-----+---------+-------+ > 3 rows in set (0.00 sec) > > mysql> LOAD DATA INFILE '/tmp/abc.txt' INTO TABLE delta.abc FIELDS > TERMINATED BY > ',' LINES TERMINATED BY '/r/n'; > ERROR 13 (HY000): Can't get stat of '/tmp/abc.txt' (Errcode: 13) > mysql> exit > Bye > [EMAIL PROTECTED] ~]$ date > Thu Apr 12 08:53:37 BST 2007 > [EMAIL PROTECTED] ~]$ > [EMAIL PROTECTED] ~]$ > > (I've even tried it as root, same result. this implies to me that the > source of > the message is with mysql rather than linux per se.) > > > > thanks, > > Thufir > > > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] > > > -- > This message has been scanned for viruses and > dangerous content by OpenProtect(http://www.openprotect.com), and is > believed to be clean. > -- This message has been scanned for viruses and dangerous content by OpenProtect(http://www.openprotect.com), and is believed to be clean. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
