MySQL Forums
Forum List  »  Newbie

MySQL limits on large files?
Posted by: Gooo Fy
Date: December 31, 2004 05:54PM

Hi,

I am developing a secure file upload/download site.

My approach is to use an account driven system which allows for file upload/download.
The files will be "absorbed" into the database directly, as opposed to leaving them on the web file structure.
The file downloads will be by "releasing" from the database.

My basic application operates currently, however, I am running into a limit problem.

I cannot upload beyond 17MB file.

I am on WinXP, PHP v 4.3.10, MySQL v 4.1.8, and access to Apache v2.0.52 (port 80) and Abyss v 1.2.3.0 (port 8000).

I have learned that these variables with upload influences are...

PHP: file_uploads = on
PHP: post_max_size = 30MB
PHP: upload_max_filesize = 30MB

MySQL: max_allowed_packet = 30MB

Any others?

I changed my upload script to process the file in 2 parts:
1) Upload the file to the web site
2) Import the file into the database.

Results:
1) The file appears on the web site properly
2) Problem encountered "MySQL server has gone away".

Thanks in advance

Options: ReplyQuote


Subject
Written By
Posted
MySQL limits on large files?
December 31, 2004 05:54PM
December 31, 2004 07:32PM
January 01, 2005 04:07PM
January 02, 2005 02:47PM
January 26, 2005 11:39AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.