[14:30:02] Why does the Wikipedia API return array dispear ? [17:42:36] hi, I was importing a database in mw with the maintenance/importDump.php script and had a power failure. I don't know how far it went in the import, is there a way to know how much was imported to skip to this part? thanks [17:58:15] myier: you may be able to check Special:AllPages on your wiki to see what the last thing it imported was. Not sure if imports show in RecentChanges or not. You could also check the revision table to see what the most recent revision is (that'll probably be the easiest way if you're comfortable with SQL) [18:46:15] thanks Skizzerz; I'm not super strong with SQL, but not knowing the layout or having an idea where this information could be will make it difficult, do you know in what table this could be at least? [19:35:29] myier: sorry I was afk. The table is called revision [19:35:43] you want to look at the most recent entry in it [19:35:48] (aka the one with the largest rev_id) [19:36:13] that in turn will have a page_id saying which page that revision is associated with, which may help you determine where your import left off [19:38:03] something like the following query: SELECT page_namespace, page_title FROM revision JOIN page ON rev_page = page_id WHERE rev_id = (SELECT MAX(rev_id) FROM revision); [22:12:43] thanks Skizzerz I'll try that. the query doesn't work, but if I replace rev_id by page_id, it takes a while, so that must be it [22:19:11] That query should wokr fine [22:19:22] Why doesn't it work? [22:23:38] the pages in the xml file are in page id order aren't they? so just checking for max page id ought to get that... unless they imported the page table straight up [22:23:45] also: happy new year! [22:25:36] or if importDump doesn't preserve page ids, it's still true that just seeing what max(page_id) is and then getting the title for that should let you grep into the xml dump to find that page and export from that on [22:41:15] * Delaware thinks Reedy will make fun of him for the attempted patch of GlobalBlocking [22:59:43] this is weird, the whole thing about amending an existing commit rather than making a bunch of your own