List:General Discussion« Previous MessageNext Message »
From:thufir Date:June 26 2014 1:54am
Subject:Re: error 29, file not found (errcode: 13)
View as plain text  
I followed the manpage for mysqlimport:


thufir@dur:~$ 
thufir@dur:~$ mysql -e 'CREATE TABLE imptest(id INT, n VARCHAR(30))' test
ERROR 1045 (28000): Access denied for user 'thufir'@'localhost' (using 
password: NO)
thufir@dur:~$ 
thufir@dur:~$ 
thufir@dur:~$ mysql -e 'CREATE TABLE imptest(id INT, n VARCHAR(30))' test 
-u root -p
Enter password: 
ERROR 1049 (42000): Unknown database 'test'
thufir@dur:~$ 
thufir@dur:~$ mysql -u root -p
Enter password: 
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 54
Server version: 5.5.37-0ubuntu0.14.04.1 (Ubuntu)

Copyright (c) 2000, 2014, Oracle and/or its affiliates. All rights 
reserved.

Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.

Type 'help;' or '\h' for help. Type '\c' to clear the current input 
statement.

mysql> create database test;
Query OK, 1 row affected (0.01 sec)

mysql> quit
Bye
thufir@dur:~$ 
thufir@dur:~$ mysql -e 'CREATE TABLE imptest(id INT, n VARCHAR(30))' test 
-u root -p
Enter password: 
thufir@dur:~$ 
thufir@dur:~$ ed
a
100	Max Sydow
101	Count Dracula
.
w imptest.txt
32
q
thufir@dur:~$ 
thufir@dur:~$ od -c imptest.txt 
0000000   1   0   0  \t   M   a   x       S   y   d   o   w  \n   1   0
0000020   1  \t   C   o   u   n   t       D   r   a   c   u   l   a  \n
0000040
thufir@dur:~$ 
thufir@dur:~$ mysqlimport --local test imptest.txt -u root -p
Enter password: 
test.imptest: Records: 2  Deleted: 0  Skipped: 0  Warnings: 0
thufir@dur:~$ 
thufir@dur:~$ mysql -e 'SELECT * FROM imptest' test -u root -p
Enter password: 
+------+---------------+
| id   | n             |
+------+---------------+
|  100 | Max Sydow     |
|  101 | Count Dracula |
+------+---------------+
thufir@dur:~$ 
thufir@dur:~$ 


so this looks like the route to go.



-Thufir

Thread
error 29, file not found (errcode: 13)thufir23 Jun 2014
  • Re: error 29, file not found (errcode: 13)Scott Helms23 Jun 2014
    • Re: error 29, file not found (errcode: 13)Carsten Pedersen23 Jun 2014
  • Re: error 29, file not found (errcode: 13)Michael Dykman23 Jun 2014
  • Re: error 29, file not found (errcode: 13)Divesh Kamra23 Jun 2014
  • Re: error 29, file not found (errcode: 13)thufir24 Jun 2014
    • Re: error 29, file not found (errcode: 13)Reindl Harald24 Jun 2014
  • Re: error 29, file not found (errcode: 13)thufir24 Jun 2014
  • Re: error 29, file not found (errcode: 13)thufir26 Jun 2014