List:General Discussion« Previous MessageNext Message »
From:Mogens Melander Date:April 12 2007 9:14am
Subject:Re: can't import
View as plain text  
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:
>
> [thufir@localhost ~]$
> [thufir@localhost ~]$ ll /tmp/abc.txt
> -rw-r--r-- 1 thufir thufir 33 Apr 12 06:59 /tmp/abc.txt
> [thufir@localhost ~]$ cat /tmp/abc.txt
> A1, B1, C1
> A2, B2, C2
> A3, B3, C3
> [thufir@localhost ~]$ 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
> [thufir@localhost ~]$ date
> Thu Apr 12 08:53:37 BST 2007
> [thufir@localhost ~]$
> [thufir@localhost ~]$
>
> (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/mysql?unsub=1
>
>
> --
> 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.

Thread
can't importThufir12 Apr
  • Re: can't importChris12 Apr
  • Re: can't importMogens Melander12 Apr
  • Re: can't importThufir13 Apr
    • Re: can't importChris13 Apr
    • Re: can't importMogens Melander13 Apr
  • Re: can't importThufir13 Apr
    • Re: can't importChris16 Apr
  • Re: can't importThufir23 Feb