MySQL Forums
Forum List  »  Newbie

Re: LOAD DATA output
Posted by: Paul McArdle
Date: June 30, 2005 08:38AM

warnings & all statements mainly,
You need mysqlimport,

http://dev.mysql.com/doc/mysql/en/mysqlimport.html

mysqlimport -L -r --host=hostm --user=myUserName --password=myPassWord myDataBase /product_type.txt > ./result.txt

Change mySqlnn, myUserName, myPassWord & myDatabase to suit.
Change ./product_type.txt to suit.
The -L tells mysql the file is local.
the -r tells mysql to replace rows I think default is add
Oh, by the way mysql will look for the table called product_type to do the import into.

If you look at the result.txt you should see somethinf like...
test.b: Records: 4 Deleted: 0 Skipped: 0 Warnings: 0

Options: ReplyQuote


Subject
Written By
Posted
June 30, 2005 07:19AM
Re: LOAD DATA output
June 30, 2005 08:38AM
June 30, 2005 09:36AM
June 30, 2005 03:59PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.