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 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql
