* Uploading files with PHP into MySQL

From Edgar BV Wiki
Jump to: navigation, search

For this to work, the php.ini and my.cnf have to be changed:

php.ini


post_max_size = 200M ; SET FOR LARGE FILE BLOBBING upload_max_filesize = 200M ; STANDARD 2M FOR LARGE FILE BLOBBING SET TO 200M file_uploads = On max_execution_time = 120  ; Maximum execution time of each script, in seconds (UNIX only) DEFAULT TO 30 BUT FOT LARGE FILE BLOBBING SET TO 120 over 100Mbit, 10 MB ~~ 1 minute, so for 200MB files, need to up this to 1200 memory_limit = 50M  ; Maximum amount of memory a script may consume (8MB) DEFAULT TO 8M BUT FOR LARGE FILE BLOBBING SET TO 50M

my.cnf


set-variable = sort_buffer=200M ; DEFAULT 2M SET TO 200M FOR LARGE FILE BLOBBING set-variable = record_buffer=200M ; DEFAULT 2M SET FOR LARGE FILE BLOBBING set-variable = max_allowed_packet=200M ; DEFAULT 1M SET TO 200M FOR LARGE FILE BLOBBING set-variable = tmp_table_size = 200M ; SET FOR LARGE FILE BLOBBING set-variable = max_allowed_packet=200M ; DEFAULT 16M SET FOR LARGE FILE BLOBBING