Mogens Melander <mogens <at> fumlersoft.dk> writes:
>
> 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';
I think I fixed it, at least as best I could. still same result:
[thufir@localhost ~]$
[thufir@localhost ~]$
[thufir@localhost ~]$ su - mysql
Password:
-bash-3.1$
-bash-3.1$ mysql -u root -p
Enter password:
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 18 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.40 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.37 sec)
mysql> LOAD DATA INFILE '/tmp/abc.txt' INTO TABLE delta.abc FIELDS TERMINATED BY
',' LINES TERMINATED BY '\n';
ERROR 13 (HY000): Can't get stat of '/tmp/abc.txt' (Errcode: 13)
mysql> ;
ERROR:
No query specified
mysql> quit
Bye
-bash-3.1$ exit
logout
[thufir@localhost ~]$
[thufir@localhost ~]$ cat /tmp/abc.txt -n
1 A1, B1, C1
2 A2, B2, C2
3 A3, B3, C3
[thufir@localhost ~]$
[thufir@localhost ~]$ cat /tmp/abc.txt
A1, B1, C1
A2, B2, C2
A3, B3, C3
[thufir@localhost ~]$
[thufir@localhost ~]$
[thufir@localhost ~]$
[thufir@localhost ~]$ ll /tmp/abc.txt
-rw-r--r-- 1 thufir thufir 33 Apr 12 06:59 /tmp/abc.txt
[thufir@localhost ~]$
[thufir@localhost ~]$
[thufir@localhost ~]$ date
Fri Apr 13 08:33:44 BST 2007
[thufir@localhost ~]$
[thufir@localhost ~]$
[thufir@localhost ~]$
thanks,
Thufir
