I have dug until I'm virtually blue in the face with trying to resolve this. I've tried using mwdumper.jar instead, but get the same error regardless of the --format option I type in.
At least the mwimport.pl file continues to build the Database. MWDumper stops processing. I don't work with Databases often and what little I do know is from MS-SQL and not MySQL. Any thoughts?
System Config:
WAMP v.3.0.6 on Windows 7 x64
– Apache 2.4.23
– PHP 5.6.25/7.0.10
– MySQL 5.7.14
– PhpMyAdmin 4.6.4
– Adminer 4.2.5
– PhpSysInfo 3.2.5
Command used:
type enwiki-20170401-pages-articles.xml | perl mwimport.pl | mysql -f -u wikimirror -p wikimirror -D wikimirror
Err and Progress Output:
ERROR 1054 (42S22) at line 207: Unknown column 'page_counter' in 'field list'
ERROR 1054 (42S22) at line 630: Unknown column 'page_counter' in 'field list'
ERROR 1054 (42S22) at line 965: Unknown column 'page_counter' in 'field list'
ERROR 1054 (42S22) at line 1394: Unknown column 'page_counter' in 'field list'
ERROR 1054 (42S22) at line 1872: Unknown column 'page_counter' in 'field list'
ERROR 1054 (42S22) at line 2424: Unknown column 'page_counter' in 'field list'
1000 pages ( 71.429/s), 1000 revisions ( 71.429/s) in 14 seconds
ERROR 1054 (42S22) at line 2972: Unknown column 'page_counter' in 'field list'
ERROR 1054 (42S22) at line 3356: Unknown column 'page_counter' in 'field list'
ERROR 1054 (42S22) at line 3761: Unknown column 'page_counter' in 'field list'
ERROR 1054 (42S22) at line 4298: Unknown column 'page_counter' in 'field list'
ERROR 1054 (42S22) at line 4991: Unknown column 'page_counter' in 'field list'
ERROR 1054 (42S22) at line 5562: Unknown column 'page_counter' in 'field list'
2000 pages ( 51.282/s), 2000 revisions ( 51.282/s) in 39 seconds
This will go on throughout the entire import process. I'd like to get is resolved and understand this better so I'm comfortable with the proof of concept I'm trying to make.