October 25, 2006

mysqlimport

Filed under: Unix Admin — HanaDaddy @ 2:06 pm

input file:

1. tablename.txt
2. Tab deliminated by default
3. use full path with all the parent path readable by mysql user

$> mysqlimport -u user -p dbname /path/to/input/tablename.txt

Also if there is autoincrement field , use number 0.

No Comments »

No comments yet.

RSS feed for comments on this post. TrackBack URI

Leave a comment

 

45 queries. 0.299 seconds. Powered by WordPress