Large file stuck in table

[Bastien]

One of our developers has a large problem. He managed to get a 17M file into the db by looping thru and chunking and appending the data into a blob field.

Now he can't get it out. :-(

Tried
PHP 4
ASP / myODBC

environs:
mysql 4.016
php 4.3.7
iis
myodbc 3.51

error is : exceeded max_allowed_packet yet both php and mysql have been configged to handle 32M files.

Any ideas?

Bastien

Cat, the other other white meat

 

[ericbrunson]

Is the connection via network or local connection? If it's network, I'd try it via local socket. There may be something in the networking protocol that's preventing it.

 

[Bastien]

local socket from webserver to db (both are on the same machine)

Bastien

Cat, the other other white meat

 

[ericbrunson]

Hmmm, then I got nothing.

 

[sleipnir214]

I think that rather than chunk the data into one table column, you'll have to either:[ul][li]store the data on the filesystem and the filename in the database or[/li][li]use multiple rows to store the binary information -- store it as chunks, as it were, and fetch and reassemble the chunks as needed[/li][/ul]


Want the best answers? Ask the best questions!

TANSTAAFL!!

 

[Bastien]

File system is the route that we are taking. I thought there might have been some other server setting that could be tuned to handle the larger files, though my research has turned up nothing at this point.


Bastien

Cat, the other other white meat

 

[ericbrunson]

Definitely sounds like something is not working as designed.