[ale] OT: MySQL Blobs

[Zyman, Andy]

Christopher,
I'm not sure how MYSQL is working with BLOBs, but in Oracle i wouldn't put
blobs into the tablespace. just store them on FS. using veritas blib backup
u are getting gain in decreased backup time. in other words - no advantages
as far as i can see. 

> -----Original Message-----
> From: Christopher Fowler [mailto:cfowler at outpostsentinel.com]
> Sent: Thursday, July 10, 2003 8:52 AM
> To: ale at ale.org
> Subject: [ale] OT: MySQL Blobs
> 
> 
> 
> 
> I'm working on a media center for home and would like to store
> media files such as DivX and MP3 in MySQL as blobs.  
> 
> When I do this:
> 
> instert into mp3 ('Song #1', '
> 
> I then cat the mp3 file to the script so the second value is the
> actuall binary data of the file.  Do I need to convert the data
> in any way to avoid certain reserved characters like the '.  I want
> to do a final source create.sql and hopefully my song is stored in 
> the database.
> 
> The next question is on using a raw device as a database.  When I did
> a lot of Oracle we used to use raw devices as database devices instead
> of files.  Is this possible in MySQL.  I am striving to create
> a system that does not have to be cleanly shut down.  I may 
> have to use
> something like JFFS2 or ReiserFS to do this but I would like to not
> have to worry about shutdown procedures.  
> 
> I have not determined what type of interface I am going to create to
> extract the media files.  I may just use Java or possible Qt.  
> 
> Thanks,
> Chris
> 
> 
> _______________________________________________
> Ale mailing list
> Ale at ale.org
> http://www.ale.org/mailman/listinfo/ale
> 
_______________________________________________
Ale mailing list
Ale at ale.org
http://www.ale.org/mailman/listinfo/ale