I got this error in the middle of the process: ERROR 1064 (42000) at line 1803: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ''{{pp-move-indef}}\n{{Anarchism sidebar}}\n'''Anarchism''' is a [[politica' at line 1
I got the tables.sql file from here ( http://svn.wikimedia.org/viewvc/mediawiki/trunk/phase3/maintenance/tables.sq...) and it does not even have more than 1500 lines so I'm not sure what the line number above refer to.
Again, here's the full output message if someone needs it: http://pastebin.com/BEtGTEAA Also, I have seen some data in my wikidb.
Thanks,
On Thu, May 24, 2012 at 6:19 PM, Khanh Nguyen ndkhanh824@gmail.com wrote:
Thank you very much Brion. That fixes my problem.
On Thu, May 24, 2012 at 6:05 PM, Brion Vibber brion@pobox.com wrote:
On Thu, May 24, 2012 at 3:01 PM, Khanh Nguyen ndkhanh824@gmail.com wrote:
However, I got this error: "ERROR 1146 (42S02) at line 33: Table 'wikidb.text' doesn't exist". You can see the detail output messages from the link below: http://pastebin.com/Y6WXhxnq
mwdumper's conversion to SQL doesn't actually create the tables for you, it just inserts data into them assuming they already exist.
You can grab maintenance/tables.sql from a MediaWiki download and source that into your database first to create the empty tables.
-- brion _______________________________________________ MediaWiki-l mailing list MediaWiki-l@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/mediawiki-l