Deadend pages/How to update

Download and install the MySQL database engine from the [http://dev.mysql.com/ MySQL web site]. Download the latest ''en'' database dump from the [http://download.wikimedia.org/ 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.

See other meanings of words starting from letter:

D

DA | DB | DC | DE | DF | DG | DH | DI | DJ | DK | DL | DM | DN | DO | DP | DR | DS | DT | DU | DW | DX | DY | DZ |

Words begining with Deadend_pages/How_to_update:

Deadend_pages/How_to_update