[asterisk-users] Record calls as BLOB into MySQL?

[Tony Mountifield]

In article <CADBM-wiAgu9ALX1rqf1e_3Di3piPznYhiLT5huYC851spzHjsA at mail.gmail.com>,
Stefan at WPF <stefan.at.wpf at googlemail.com> wrote:
> 
> Thanks Danny,
> 
> do you mean better put the filename into the database?

I would normally just put the filename into the database. However, if you
had a good reason for storing the actual content in a BLOB field, you could
use the LOAD_FILE() function to copy from the file to the field. See

http://dev.mysql.com/doc/refman/5.0/en/string-functions.html#function_load-file

You would need to make sure your MySQL configuration had a suitable value
for max_allowed_packet, as mentioned in the above section.

Cheers
Tony


> 2012/8/31 Danny Nicholas <danny at debsinc.com>
> 
> > Probably “possible” but not recommendable.  You have no idea how long your
> > call will or will not be.  It would be better to record the call into a wav
> > or gsm file, then put that into the blob.****
> >
> > ** **
> >
> > *From:* asterisk-users-bounces at lists.digium.com [mailto:
> > asterisk-users-bounces at lists.digium.com] *On Behalf Of *Stefan at WPF
> > *Sent:* Friday, August 31, 2012 10:22 AM
> > *To:* Asterisk Users Mailing List - Non-Commercial Discussion
> > *Subject:* [asterisk-users] Record calls as BLOB into MySQL?****
> >
> > ** **
> >
> > Hello all,
> >
> > is it possible, to record calls directly as BLOB into a MySQL database?
> >
> >
> > Best regards
> > Stefan****
> >
> > --
> > _____________________________________________________________________
> > -- Bandwidth and Colocation Provided by http://www.api-digital.com --
> > New to Asterisk? Join us for a live introductory webinar every Thurs:
> >                http://www.asterisk.org/hello
> >
> > asterisk-users mailing list
> > To UNSUBSCRIBE or update options visit:
> >    http://lists.digium.com/mailman/listinfo/asterisk-users
> >
> 
> -=-=-=-=-=-
> [Alternative: text/html]
> -=-=-=-=-=-
> -=-=-=-=-=-
> 
> --
> _____________________________________________________________________
> -- Bandwidth and Colocation Provided by http://www.api-digital.com --
> New to Asterisk? Join us for a live introductory webinar every Thurs:
>                http://www.asterisk.org/hello
> 
> asterisk-users mailing list
> To UNSUBSCRIBE or update options visit:
>    http://lists.digium.com/mailman/listinfo/asterisk-users
> -=-=-=-=-=-


-- 
Tony Mountifield
Work: tony at softins.co.uk - http://www.softins.co.uk
Play: tony at mountifield.org - http://tony.mountifield.org