Prev | Current Page 135 | Next

Marc Delisle

"Mastering phpMyAdmin 2.11 for Effective MySQL Management"


Other Limits
The system administrator can use the php.ini file or the web server's virtual host
configuration file to control uploads on the server.
The upload_max_filesize parameter specifies the upper limit or the maximum file
size that can be uploaded via HTTP. This one is obvious, but another less obvious
parameter is post_max_size. Because HTTP uploading is done via the POST
method, this parameter may limit our transfers. For more details about the POST
method, please refer to http://en.wikipedia.org/wiki/Http#Request_methods.
??? ???
Chapter 8
[ 141 ]
The memory_limit parameter is provided to avoid web server child processes
from grabbing too much of the server memory??”phpMyAdmin also runs as a child
process. Thus, the handling of normal file uploads, especially compressed dumps,
can be compromised by giving this parameter a small value. Here, no preferred
value can be recommended??”it depends on the size of uploaded data. The memory
limit can also be tuned via the $cfg['MemoryLimit'] parameter in config.inc.php,
as seen in Chapter 7.
Finally, file uploads must be allowed by setting file_uploads to On. Otherwise,
phpMyAdmin won't even show the Location of the textfile dialog. It would be
useless to display this dialog, because the connection would be refused later by the
PHP component of the web server.


Pages:
123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139 140 141 142 143 144 145 146 147