Creating a huge media database and storing the media *inside* of mysql
is a big mistake.
Store the media in a filesystem. Store metadata about the media in mysql.
Good luck.
Peter
On 7/10/06, Shain Lee <[EMAIL PROTECTED]> wrote:
Hi ,
I'm just behind a mulimedia database , that wanted to be online with WAP
contents. So , i decided to go ahead with mysql , and i installed mysql latest
5.0 in fedora core 5 with innoDB .upto now every thing success.
But , my worries is , how can i created huge mulimedia database with mysql ?
There are lots of subcatagories , in each and every main catagories ,
for example ,
Movie stars ---> actors ----- > hollywood--->abc--->ddd
bollywood-->aaa---->sss
actress -----> hollywood---->aaa
bollywood--->qqq
like that , there should be alot of main catagories and sub catagotries. All
contents types are available , like wallpaper , greetings, ring tones ...,
movies clips .....etc.
Those contents are supposed to stored as BLOB in mysql database itself.
So , can somebody , help me to created most reliable mysql - multimedia
database ?
any ideas and comments are welcome ,
Thanx in advance,
Shaine.
---------------------------------
All new Yahoo! Mail "The new Interface is stunning in its simplicity and ease of
use." - PC Magazine
--
find videoblogs: http://mefeedia.com
my blog: http://poorbuthappy.com/ease/
my job: http://petervandijck.net
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
