Why not change VIDEO -> VIDEO_PATH and just use the directory path as a
varchar() field to point you to the file stored on your computer. That way
you don't have to worry about it. Whenever I need to use images or large
files of some type, I just put it in a directory and reference the path to
i
To: "Steven Wu" <[EMAIL PROTECTED]>
> Cc: <[EMAIL PROTECTED]>
> Sent: Tuesday, July 22, 2003 12:12 PM
> Subject: Re: store video file into MySQL database server
>
>
> > On Tue, Jul 22, 2003 at 12:03:44PM -0700, Steven Wu wrote:
> > > Hi Need emergen
1st search list for binary storage to read about pro/cons (been debated
before)
If you still want to do it either use load_file, or a loader
application...
I don't reccomend using longblob to store big files.. Use the 64k blob
and inode/chunk the data.. better for streaming it out if that's wha
: "Steven Wu" <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>
Sent: Tuesday, July 22, 2003 12:12 PM
Subject: Re: store video file into MySQL database server
> On Tue, Jul 22, 2003 at 12:03:44PM -0700, Steven Wu wrote:
> > Hi Need emergency help:
> >
> > I
On Tue, Jul 22, 2003 at 12:03:44PM -0700, Steven Wu wrote:
> Hi Need emergency help:
>
> I am doing some project use the MySQL to store the video file. The
> format of video is either avi or mpg. However I can not successfully
> insert the video file into the cooresponding field of a table by
> us
Your maximum packet size must be greater than the size of the video file.
Steven Wu wrote:
Hi Need emergency help:
I am doing some project use the MySQL to store the video file.
The format of video is either avi or mpg. However I can not successfully insert the
video file into the coorespond
At 12:03 -0700 7/22/03, Steven Wu wrote:
Hi Need emergency help:
I am doing some project use the MySQL to store the video file.
The format of video is either avi or mpg. However I can not
successfully insert the
video file into the cooresponding field of a table by using the
"LOAD_FILE" func
