Wikimedia Bugzilla is closed!

Hacked up some harvesting a time ago:

mysql> SELECT COUNT(*) FROM image;
+----------+
| COUNT(*) |
+----------+
|  1263653 |
+----------+
1 row in set (0.00 sec)

CREATE TABLE `image` (
  `country` varchar(10) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL DEFAULT '',
  `id` varchar(25) NOT NULL DEFAULT '0',
  `img_name` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL DEFAULT '',
  PRIMARY KEY (`country`,`id`,`img_name`),
  KEY `country_id` (`country`,`id`),
  KEY `img_name` (`img_name`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8

Should set up daily harvesting so this can be used by other tools.