From: Hoo man <hoo@online.de>

Date: Thu, 07 Nov 2013 22:52:38

Is this still needed? If so, I'll resolve that soon.

SQL:

SELECT img_name, img_metadata FROM image;

img_metadata needs to be unserialized using PHP then, that's easy to do but will take a bit.

From: karthik Sripal <karthik_sripal@yahoo.co.in>

Date: Fri, 08 Nov 2013 00:22:53

Yes please , thank you

From: Hoo man <hoo@online.de>

Date: Sat, 09 Nov 2013 01:09:48

Hi, please notice that I didn't do any further preprocessing of the meta data, I've just dumped it as a JSON structure.

I've chose the following format (delimiter is a tab):
Filename Json with metadata

Result:
https://tools.wmflabs.org/hoo/dbq/dbq-207.gz (about 11GiB unpacked)

From: karthik Sripal <karthik_sripal@yahoo.co.in>

Date: Sat, 09 Nov 2013 01:16:21

Thank you very much, This helps ![][1]

[1]: https://jira.toolserver.org/images/icons/emoticons/smile.gif

This bug was imported as RESOLVED. The original assignee has therefore not been
set, and the original reporters/responders have not been added as CC, to
prevent bugspam.

If you re-open this bug, please consider adding these people to the CC list:
Original assignee: hoo@online.de
CC list: hoo@online.de