* Uploading files with PHP into MySQL
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