Tuesday, October 25, 2011

phpMyAdmin: You probably tried to upload too large file

Sometimes when importing database into MySQL, you may face with the error message of "You probably tried to upload too large file. Please refer to documentation for ways to workaround this limit."

To resolved this issue in phpMyAdmin, you will need to increase the limit parameters in php.ini. For example, in my test site:

max_execution_time = 120 ; Maximum execution time of each script, in seconds (def. 30)
max_input_time = 180 ; Maximum amount of time each script may spend parsing request data (def. 60)
memory_limit = 128M ; Maximum amount of memory a script may consume (def. 128mb)
upload_max_filesize = 128M ; Maximum allowed size for uploaded files. (def. 2mb)
post_max_size = 16M ; (def. 8mb)

No comments:

Post a Comment