Extract files from a mysql database

------=_Part_24863_21408905.1138778844483
Content-Type: text/plain; charset=UTF-8
Content-Transfer-Encoding: base64
Content-Disposition: inline

SGkgYWxsLAoKSSBhbSBuZXcgdG8gdGhpcyBsaXN0IGFuZCB0aGlzIGlzIG15 IGZpcnN0IHBvc3Rp
bmcuIFBsZWFzZSBjb3JyZWN0IGlmIG15Cm1haWwgaXMgbm90IHNwZWNpZmlj IHRvIHRoZSBsaXN0
LgpJIGFtIHdvcmtpbmcgb24gYnVnemlsbGEgd2hpY2ggaGFzIGEgbXlzcWwg ZGF0YWJhc2UgY2Fs
bGVkICJidWdzIi4gSXQgaGFzIGEKdGFibGUgbmFtZWQgImF0dGFjaG1lbnRz IiBpbiBpdC4gQWxs
IHRoZSBidWcgYXR0YWNobWVudHMgYXJlIHN0b3JlZCBpbiB0aGUKZGF0YWJh c2UgaW4gYSB6aXAg
Zm9ybWF0LiB3aGF0IGkgYW0gdHJ5aW5nIHRvIGRvIGlzLCBpIHdhbnQgdGhl IGF0dGFjaG1lbnQK
dG8gYmUgZXh0cmFjdGVkIHRvIG15IGZpbGUgc3lzdGVtIGZyb20gdGhlIGRh dGFiYXNlIGFuZCBp
IGFtIHRyeWluZyBpdAp0aHJvdWdoIGEgcGVybCBzY3JpcHQgdXNpbmcgREJJ IGFuZCBEQkQ6Om15
c3FsIG1vZHVsZXMuCkkgd2lsbCBnaXZlIGFuIGV4YW1wbGU6IHRoZXJlIGlz IGEgYnVnIGhhdmlu
ZyBidWdfaWQgNTYyNiwgaXQgaGFzIGEKYXR0YWNobWVudCBuYW1lZCA1NjI2 LnppcC4gbm93IG15
IHNjcmlwdCBzaG91bGQgZXh0cmFjdC9jb3B5IHRoaXMgZmlsZSgKNTYyNi56 aXApIHRvIGEgZHJl
Y3Rvcnkgb24gdGhlIGZpbGUgc3lzdGVtLiBUaGUgc2NyaXB0IHdoaWNoIGkg aGF2ZSB3cml0dGVu
CmdldHMgbWUgdGhlIGNvbnRlbnRzIG9mIHRoZSBmaWxlIG9ubHkgYW5kIG5v dCB0aGUgZmlsZS4g
QnV0IHRoZSBjb250ZW50IGkKZ3Vlc3MgaXMgc3RvcmVkIGluIGEgYmluYXJ5 IGZvcm1hdChCTE9C
KSBzbyBpIGFtIG5vdCBhYmxlIHRvIHJlYWQgYW55dGhpbmcKaW4gdGhlIGNv bnRlbnQuIEJlbG93
IGlzIG15IGNvZGUKCiMhdXNyL2xpYi9wZXJsCnVzZSBEQkk7Cm15ICRkYmgg PQpEQkktPmNvbm5l
Y3QoIkRCSTpteXNxbDpkYXRhYnNlPVBidWdzO2hvc3Q9YXBwbGV0ZXN0Iiwi cm9vdCIsImRlbHRh
emlhIix7J1JhaXNlRXJyb3IiCj0+IDF9KTsKbXkgJHN0aCA9ICRkYmgtPnBy ZXBhcmUoc2VsZWN0
IHRoZWRhdGEgZnJvbSBhdHRhY2htZW50cyB3aGVyZQphdHRhY2hfaWQ9MTQz Iikgb3IgZGllICJj
YW4ndCBwcmVwYXJlIHN0YXRlbWVudCI7CnByaW50IlF1ZXJ5IFJlc3VsdHNc biI7CndoaWxlKG15
IEByb3cgPSAkc3RoLT5mZXRjaHJvd19hcnJheSgpKXsKcHJpbnQiQHJvd1xu IjsKfQokc3RoLT5l
eGVjdXRlIG9yIGRpZSAiY2FuJ3QgZXhlY3V0ZSBzdGF0ZW1lbnQiOwokZGJo LT5kaXNjb25uZWN0
OwoKKioqTm90ZSAtICJ0aGVkYXRhIiBpbiB0aGUgc3FsIHF1ZXJ5IHJlcHJl c2VudHMgdGhlIGNv
bnRlbnRzIG9mIHRoZSBmaWxlIGkKYW0gdHJ5aW5nIHRvIGV4dHJhY3QuCmF0 dGFjaF9pZCBpcyB0
aGUgYXR0YWNobWVudCBpZC4KVGhlIGFib3ZlIHNjcmlwdCBnaXZlcyBtZSBv bmx5IHRoZSBjb250
ZW50cyBvZiB0aGUgZmlsZSBidXQgaSB3YW50IHRoZSBmaWxlCml0c2VsZiB0 byBiZSBleHRyYWN0
ZWQgdG8gdGhlIGRpcmVjdG9yeSBvbiB0aGUgZmlsZSBzeXN0ZW0uCgpJIHNl YXJjaGVkIGluIHRo
ZSBnb29nbGUgYnV0IGRpZG4ndCBmaW5kIGFueSBzb2x1dGlvbi4gQnV0IGkg Z290IHNvbWUgaW5m
bwp0aGF0IGkgY2FuIGRvIGl0IHVzaW5nIERCSSBhbmQgREJEOjpteXNxbC4g c28gcGxlYXNlIGNh
biBhbnlvbmUgaGVscCBtZSBvdXQsCmkgd2FudCB0aGUgZmlsZXMgZnJvbSB0 aGUgdGFibGUgdG8g
YmUgY29waWVkIHRvIHRoZSBmaWxlIHN5c3RlbSBob3cgY2FuIGkgZG8KaXQg dXNpbmcgREJJIGFu
ZCBEQkQ6Om15c3FsPz8gd2hhdCBjaGFuZ2VzIHNob3VsZCBpIGRvIGluIG15 IHNjcmlwdCB0byBt
YWtlCml0IGNvcHkgZmlsZXMgZnJvbSB0aGUgZGF0YWJhc2U/ICJpIGFtIHdv cmtpbmcgb24gcmVk
IGhhdCBlbnRlcnByaXNlIGxpbnV4CjIiClBsZWFzZSBtYWlsIG1lIGlmIHlv dSBuZWVkIG1vcmUg
ZGV0YWlscy4KCldhaXRpbmcgZm9yIHlvdXIgcmVwbHkKU2hhbQo=
------=_Part_24863_21408905.1138778844483--

Re: Extract files from a mysql database

Hi,

just that it got resolved.

On Wed, 01 Feb 2006 08:50:35 +0100, Sham Prasad wrote:
> Thanks jan,
>
> I tested the code you had sent. Now its working for me.
....
> On 2/1/06, Jan Kratochvil wrote:
> >
> > On Wed, 01 Feb 2006 08:27:24 +0100, Sham Prasad wrote:
> > ...
> > > Below is my code
> >
> > This script has some typos and cannot work. But still:
> >
> > > #!usr/lib/perl
> > > use DBI;
> > > my $dbh =
> > >
> > DBI->connect("DBI:mysql:databse=Pbugs;host=appletest","root" ,"deltazia",{'RaiseError"
> > > => 1});
> > > my $sth = $dbh->prepare(select thedata from attachments where
> > > attach_id=143") or die "can't prepare statement";
> > > print"Query Results\n";
> > > while(my @row = $sth->fetchrow_array()){
> >
> > > print"@row\n";
> > local *F;
> > open F,">/tmp/file.zip" or die;
> > print F $row[0] or die;
> > close F or die;
> >
> > > }
> > > $sth->execute or die "can't execute statement";
> > > $dbh->disconnect;
> >
> >
> > Is this what you want?
> >
> >
> > Regards,
> > Lace

--
MySQL Perl Mailing List
For list archives: http://lists.mysql.com/perl
To unsubscribe: http://lists.mysql.com/perl?unsub=gcdmp-msql-mysql-modules@m .gmane.org

Re: Extract files from a mysql database

On 2/1/06, Sham Prasad wrote:

> I am working on bugzilla which has a mysql database called "bugs". It has=
a
> table named "attachments" in it.

In your special case, I'd recommend *not* to retrieve the file using
DBD::mysql, but via the Bugzilla CGI binaries. (In other way, connect
to the URL /attachments.cgi?id=3D.) That way, you leave Bugzilla the
possibility to change its database structure (which it frequently
does), and you are within Bugzillas security system.

Jochen (Bugzilla Consultant)

--
If you obey all the rules you miss all the fun. (Katharine Hepburn)

--
MySQL Perl Mailing List
For list archives: http://lists.mysql.com/perl
To unsubscribe: http://lists.mysql.com/perl?unsub=3Dgcdmp-msql-mysql-modules @m.gmane.org