searope / jwpl

Automatically exported from code.google.com/p/jwpl
0 stars 0 forks source link

datamachine: unknown command '\'' while importing #92

Closed GoogleCodeExporter closed 9 years ago

GoogleCodeExporter commented 9 years ago
Hi

I am using version 0.9.1 datamachine to create a local wikipedia database. I 
have generated all the .txt files and tried to import each file at a time. I 
got the following error:

============================================
PAGER set to stdout
PAGER set to stdout
PAGER set to stdout
PAGER set to stdout
PAGER set to stdout
ERROR at line 1: Unknown command '\''.
============================================

...when importing the Page.txt file. Has anyone else got the similar problem? 
it seems to be complaining about the '\' character inside the page content.

thanks in advance

Original issue reported on code.google.com by ziqizhan...@googlemail.com on 12 May 2012 at 10:14

GoogleCodeExporter commented 9 years ago
UPDATE: problem solved. 

the reason was that I used "mysql [dbname] < [Page.txt]"

instead of mysqlimport. It worked with previous versions of datamachine before. 
maybe this version changed data format.

Original comment by ziqizhan...@googlemail.com on 13 May 2012 at 11:18

GoogleCodeExporter commented 9 years ago
Thanks for clarifying this.
Datamachine always produced datafiles - not SQL. So this actually should not 
have worked before...

 "mysql [dbname] < [sqldump]"
works only with sql-dumps.
You could, however, also write import an SQL file containing LOAD DATA INFILE 
commands to import the txt-files - that's basically the same as using 
mysqlimport.

Original comment by oliver.ferschke on 13 May 2012 at 6:28