Issue while importing datafiles into database

[Mithun Shivakoti]

Hey,

           I have been facing an issue while extracting the 11 text files from the output folder into MYSQL database. Database and tables are perfectly created, but I am confused with the command for importing datafiles into database.

User name: midas

database name: wiki

output folder path: /home/midas/Documents/newjar1.0.0/output/

I've tried : mysqlimport -umidas -p --local --default-character-set=utf8 wiki /home/midas/Documents/newjar1.0.0/output/*.txt

But, its not working. 

PFA

Thanks!

[Mithun Shivakoti]

Could anyone please do clarify me on this regard?

[Torsten Zesch]

What is the error message?

(please keep in mind that development of JWPL stopped more than 5 years ago ...)

[Mithun Shivakoti]

Hey Torstan,

                              It isn't throwing any error but the cursor is simply going to the next line and nothing is happening. Could you just look at the code of line I have used? I am a little confused whether it is right or not.

User name: midas

database name: wiki

output folder path: /home/midas/Documents/newjar1.0.0/output/

I've tried : mysqlimport -umidas -p --local --default-character-set=utf8 wiki /home/midas/Documents/newjar1.0.0/output/*.txt

PFA 

Thanks!

[Torsten Zesch]

From the screenshot I see that you are within mysql. You need to quit mysql and run the command from your normal shell.