Our bigzilla installation has a few GB of data and no server admin. I have web administrative access to bugzilla and would like to get all of the attachments (with their original name and bug #).
I know there's a mass export of database as XML, but presumably the attachments would have to be parsed afterwards.
I can request access to server and then take a look into attachments
table in the bug database, but then, again, I will have to somehow decode the attachment data. So,
how to export all of the Bugzilla's bug attachments at once, as files?
Perhaps some desktop client has this functionality? Or someboday has a script to create a tarball?
I needed to see if there was already a script for the very same requirement and came up here. Since I didn't understand the pure SQL answer, I went on to create my own Python script. If somebody needs it in future, here it is,
The script will create directories based on the column name that is given as the argument. I'm not checking the argument since this is a quick and dirty script.