Q: I want to import 300MB .sql file into my database, but i receiving a error message like
################################################################################################
" You probably tried to upload a file that is too large. Please refer to documentation for a workaround for this limit".
################################################################################################
Answer : I want to change the memory limits in php.ini file like below
Open the php.ini fine in Linux /etc/php.ini , in Windows /etc/php5/apache2/php.ini
max_execution_time = 600Brief description about above script is shown below :
max_input_time = 180
memory_limit = 128M
upload_max_filesize = 300M
post_max_size = 300M
; Maximum execution time
of each script, in seconds
max_execution_time = 600 // By default Maximum exec time is 30 sec
;
Maximum amount of time each script may spend parsing request data. It's a good
; idea
to limit this time on productions servers in order to eliminate unexpectedly
; long
running scripts.
max_input_time = 180 // By default Maximum input time is 60 sec
; Maximum amount of memory a script may
consume (default 128mb)
memory_limit = 128M // By default Memory limit is 128mb
;
Maximum allowed size for uploaded files.
upload_max_filesize = 300M // By default Maximum allowed size is 2MB
; Maximum size of POST data that PHP will
accept.Its value may be 0 to disable the limit.
; It is ignored if POST data reading is
disabled through enable_post_data_reading.
post_max_size = 300M // By default Maximum size is 8MB
Related posts :
No comments:
Post a Comment