cant find a frm file when trying to import data into mySql
I am trying to import English wikipedia dump into MySQL so I can use the JWPL library to work with it.
I installed MySSQ, created a database named wikidump, ran a sql script that created the needed tables, and tried to run the following import command to load the data:
mysqlimport -u root-p --local --default-character-set=utf8 wikidump `pwd`/*.txt
When I do so, I get the following error:
msqlimport: Error: 1017,can't find file: '.\wilidump\@002.frm' <errno:22> when using table:*
I ran the command from the r开发者_如何学编程oot directory of the files to import. Is this okay?
Is this a problem with the db or the the files I am trying to import? Any clues on what to do next?
(Sorry, if it a simple question and I'm just missing out on something simple, I am a newbie to sql and I did my best searching for an answer.)
I got this message once when I tried to read in gzipped data files and needed to uncompress them first...
I got the problem too. It seems that the command didn't support the usage of "*". So my way to solve the problem is to list all the names of the files into another file, use the shell to add "mysqlimport ......" before every file name, the use the file as a script to repeat the import command to all the files.
精彩评论