Connecting Tech Pros Worldwide Forums | Help | Site Map

how to store video file in mysql database

Newbie
 
Join Date: Dec 2006
Posts: 1
#1: Dec 18 '06
hi friends,
i want to store a video file in mysql database, if u r having any
related code, please give me reply, i am waiting for that

ronverdonk's Avatar
Moderator
 
Join Date: Jul 2006
Location: The Netherlands
Posts: 4,139
#2: Dec 18 '06

re: how to store video file in mysql database


Show us the code you have developed up to now for your requirement. Then we will help you develop it further or in case you encounter any errors or problems.

Ronald :cool:
Expert
 
Join Date: Oct 2006
Location: NC
Posts: 1,722
#3: Dec 22 '06

re: how to store video file in mysql database


A great solution I have heard to this is to store the addresses of the video files in a DB not the video files themselves.
ronverdonk's Avatar
Moderator
 
Join Date: Jul 2006
Location: The Netherlands
Posts: 4,139
#4: Dec 22 '06

re: how to store video file in mysql database


Personally I don't like storing images and videos in a database.
I always have only the name of the file in the db and that is (performance-wise) a lot faster.

Ronald :cool:
Newbie
 
Join Date: Feb 2008
Posts: 2
#5: Feb 18 '08

re: how to store video file in mysql database


how to store video file in mysql database


hi friends,
i want to store a video file in mysql database, if u r having any
related code, please give me reply, i am waiting for that
plz if u hav any idea then rply
Newbie
 
Join Date: Feb 2008
Posts: 4
#6: Feb 18 '08

re: how to store video file in mysql database


Instead of storing videos in database you should store their URL in database and use them to access your video.
I don't know which scripting language you use so I can't give you a perfect solution.
debasisdas's Avatar
Moderator
 
Join Date: Dec 2006
Location: Bangalore ,India
Posts: 7,509
#7: Feb 18 '08

re: how to store video file in mysql database


Quote:

Originally Posted by vinayaknkadam

how to store video file in mysql database

Convert the file into binary stream and store in LOB fields.
Reply