SitePoint Sponsor

User Tag List

Results 1 to 3 of 3
  1. #1
    SitePoint Member
    Join Date
    Jan 2004
    Location
    Canada
    Posts
    13
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Question MySQL limits on large files?

    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?

    Thanks in advance
    Last edited by Gooofy; Dec 31, 2004 at 16:24.

  2. #2
    SitePoint Member
    Join Date
    Jan 2004
    Location
    Canada
    Posts
    13
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Update:

    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".

  3. #3
    SitePoint Member
    Join Date
    Jan 2004
    Location
    Canada
    Posts
    13
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    I posted it the MySQL forums aswell...
    http://forums.mysql.com/read.php?10,...0083#msg-10083


Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •