Andreas Rindler schreef:
Hi,
we are trying to extract all URLs in wiki articles from our Mediawiki
installation. We have tried Grep, Perl and Sed on mysql dumps, but it
is very difficult to get the URLs only, without some
garbage/text/comments before or after them.
Does anyone know of a better way to achieve this?
Use the externallinks table, it has all this data. If the externallinks
table is empty or incomplete, you can rebuild it with a maintenance
script (don't remember the name offhand).
Roan Kattouw (Catrope)