Dorożyński Janusz wrote:
So, is any chance that people can take from download.wikimedia.org .sql dumps? Xml dumps are completely useless for them.
No you can't get SQL dumps. :)
* The schema and compression formats keep changing, which breaks things for people trying to get at the data. * There is no longer any equivalent to the "cur table" for current-revision-only SQL dumps. * The page database now includes deleted page text, which can't be publically redistributed. * The databases as we have them contain a lot of indirection, with custom site-specific alternate tables. * A lot of text isn't even in there but is stored on another server cluster MAKING A RAW SQL DUMP USELESS IF YOU'RE NOT ON OUR SERVERS.
So straight SQL dumps for the public are not possible.
If you like you can use the mwdumper tool to convert the XML dumps to local-import-friendly SQL instead of using importDump.php (which as you note needs a bug fix). This is still experimental for that purpose and is in CVS: http://cvs.sourceforge.net/viewcvs.py/wikipedia/mwdumper/
When it's a little more tested I'll make a public release package for it.
-- brion vibber (brion @ pobox.com)