uploading file size

Question

As we all know, By default in PHP+MySQL, we can upload a file of size 1.4MB (max).

1) My Question is how can i increase the limitation of this uploading file size?

2) What is the maximum limitation for file to be uploaded in database?

Thanx for viewing my query and special thanx for answering my questin.

Answer 1

1. Change upload_max_filesize and post_max_size directives in php.ini
2. Google for mysql data types, you'll find limitations of each data type. But IIRC blob types are unlimited (ie. limited by disk size).

Answer 2

In php.ini the following parameters have an effect

• file_uploads
• upload_max_filesize
• max_input_time
• memory_limit
• max_execution_time
• post_max_size

Parameters are explained here

EDIT: For mysql limits see the reference manual, there is a parameter max_allowed_paket which defaults to 1GB, there maybe also timeouts when inserting huge amounts of data.