Hi
i want to store video files(.mpeg,.mov etc) in mysql using php.
Please tell me how to store it in database.

    I would not advise doing this as the overhead would be significant. My advise would be to store the URL to the video file within the database.

    If you still wanted to imbed video files etc.. you would want to use a BLOB type field.

      Yeah generally the filesystem does a much better job of caching/retrieving large binary objects than MySQL will.

      You should store the video on the filesystem, and then store a path /path/to/your-file.mpg in the database instead.

        Write a Reply...