Wikipedia:Deadend pages/How to update

From Wikipedia, the free encyclopedia

Download and install the MySQL database engine from the MySQL web site. Download the latest en database dump from the Wikipedia database download site. Unzip the database dump and load the resulting file into MySQL with the source command.

Now issue the SQL statement:

    select cur_title
    from cur
    where locate( '[[', cur_text ) = 0
    and cur_namespace = 0
    order by cur_title;

This will return a list of all articles that do not contain at least one '"[["' - this means they're almost certainly not wikified. Open the list in a text editor (you may find it helpful to save it using MySQL's tee command), tidy it up and cut and paste it into Wikipedia:Deadend pages.