Uploading large files (> 20MB)

[tju]

Uploading a (binary, content should not matter) file with approx. 28M causes the page: bug_file_add.php to be shown with NO content (i.e. empty page) after upload has finished, but no file has been uploaded. I've configured DATABASE upload method and setup all required parameters in my.cnf and ph...
Sorry for creating a new thread, but there was no response on my note added to a previous issue (upload problem Postby selim on Jul 08, 2005 10:23 pm).

[DaVinci]

well..
first of all i would advice you not to use DATABASE to upload so large files..upload them where mantis is installed:

change following in config_default_inc.php
[quote]# Upload destination: specify actual location in project settings
# DISK, DATABASE, or FTP.
$g_file_upload_method = DISK;[/quote]

then you have to chage this:
[quote] # Maximum file size that can be uploaded
# Also check your PHP settings (default is usually 2MBs)
$g_max_file_size = 100000000; # 100 MB[/quote]


and then you have to chnage php.ini file:
[quote]
;;;;;;;;;;;;;;;;
; File Uploads ;
;;;;;;;;;;;;;;;;

; Whether to allow HTTP file uploads.
file_uploads = On

; Temporary directory for HTTP uploaded files (will use system default if not
; specified).
upload_tmp_dir = "c:/wamp/tmp"

; Maximum allowed size for uploaded files.
; Default is 2M
; upload_max_filesize = 2M
upload_max_filesize = 90M[/quote]

remember to make back-ups of these files before you do anything

[tju]

Ok, i'll give it a try. Thks a lot.
BTW: I've just uploaded a (large) file which now is stored in the MySQL DB. How can i get rid of it.

[DaVinci]

i will suggest you to just let the file be in the database and upload it again on the DISK after you have made changes
reason is that if you deltete it you might corrupt DB

[tju]

I don't need the file anymore.
I want to get rid of it because it's blowing up the SQL Database (size >= 20MB)

[tju]

BTW: Changing to DISK upload mode works fine, even w files of size > 20MB (approx. 30MB)