Last modified: 2014-07-27 10:42:50 UTC
I downloaded the it.wikibooks database from http://download.wikimedia.org/itwikibooks/20080104/. More precisely, I downloaded the "pages-meta-current.xml.bz2" dump.
I then created this list from the database dump: http://it.wikibooks.org/wiki/Wikibooks:Elenchi_generati_offline/Libri
Since this list should contain all the books in our project, I discarded the redirects. Here is the query I used:
SELECT CONCAT( '# [[', page_title, ']]')
WHERE `page_is_redirect` LIKE 0
AND `page_namespace` LIKE 0
AND `page_title` NOT REGEXP '[:/]'
ORDER BY `page_title`;
However, in the list there is "Main_Page", which is a redirect (see http://it.wikibooks.org/w/index.php?title=Main_Page&redirect=no).
I looked in my database ("page" table) with phpMyAdmin and noted that the "page_is_redirect" field for "Main_Page" is 0.
MediaWiki doesn't recognize "Main_Page" as a redirect, but that IS a redirect!
This error occurred also in the previous lists.
Fixed description, this is an import problem, not an export/download problem.
*** This bug has been marked as a duplicate of bug 10931 ***
This bug is about the fact that Special:Import does not create entries in the redirect table. Bug 10931 is about missing entries in the redirect table in a particular wiki, which are missing for reasons unrelated to Special:Import.
Another XML import thing to check for you, Ariel. :)
Import/export redirect handling has been overhauled since 2008, and since I can't reproduce this bug locally, we can safely assume it has gone away.