How to import text files in to mysql database

[chandu.pr...@vit.ac.in]

guys can you explain the steps to upload txt files in to database.

[chandu.pr...@vit.ac.in]

I have seen a import statement in one of the post by oliver ferschke. I am using mysql 5.6.26-log MySQLCommunity Server(GPL) version

mysqlimport -uUSER -hHOST -p --local --default-character-set=utf8 DATABASE_NAME `pwd`/*.txt

here are the parameters :
user = root
host = localhost
password=Ch@n1234
databasename =wikipedia

i didnt understand the `pwd`/*.txt thing in the query

Can you give a sql query  with all these details given above.

please help me with this thing


-Chandu Prakash

[xavier sumba]

Hello Chandu,

This means `pwd`/*.txt (print working directory) and it's the path of your files in the output folder.

I used this line to import text files: 

mysqlimport -uroot -p --local --default-character-set=utf8 wiki_dumps $wikipedia_path/dumps/en/20160113/output/*.txt

Hope solve your problem.

Cheers.