How to store the audio files with metadata(like artist name, duration,path) in mysql database?

I am doing a project of olnine music straming website.I have to store large amount of audio file with metadata(like: artist name,full duration,path of audio file,image for that audio file etc.). How can i store those audio file in mysql database and retrive them for streming.
sudipta swainAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Doug WaltonDatabase AdministratorCommented:
You can store files in MySQL tables using one of the BLOB datatypes.  (MEDIUMBLOB can handle 16 MB)

You'll want a table with something like:
create table music (
id int not null auto_increment,
name varchar(100) not null,
file MEDIUMBLOB not null,
primary key(id)
);

Open in new window


If you need to keep track of the metadata separately you'll have to create more columns (artist, album, title, etc.).

This tutorial goes over it pretty well: http://www.php-mysql-tutorial.com/wikis/mysql-tutorials/uploading-files-to-mysql-database.aspx

Hope that helps!
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
Phillip BurtonDirector, Practice Manager and Computing ConsultantCommented:
I don't know from your question whether you have already extracted that information.

You could probably import into MySQL from a spreadsheet which contains the metadata - see http://www.filecats.co.uk/metadata-extended-document-properties/audio-video/ for how to create that spreadsheet.
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
MySQL Server

From novice to tech pro — start learning today.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.