In article <cadbm-wiagu9alx1rqf1e_3di3pipznyhilt5huyc851spzh...@mail.gmail.com>, Stefan at WPF <[email protected]> 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 <[email protected]> > > > 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:* [email protected] [mailto: > > [email protected]] *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: [email protected] - http://www.softins.co.uk Play: [email protected] - http://tony.mountifield.org
-- _____________________________________________________________________ -- 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
