phpmyadmin Question posted in
The official documentation can be found here.

phpMyAdmin not able to uplaoad a db

I want to upload a big db to my localhost(docker with apache). The first problem was that I can’t upload a big file than I add a uploads.ini and add it to the docker-compose.yml. Now you can see in phpMyAdmin that I can upload 200Mib. Then there was an error that the execution time is too long. Then I add the max_execution_time to the uploads.ini and there is another error that says

(Maximum execution time of 300 seconds exceeded in /var/www/html/libraries/classes/File.php on line 741)

and I don’t have any idea how I can find out where the code is. Please help me!

Tags:

2

Answers


  1. Chosen as BEST ANSWER
    0

    I solved the problem by unzip my db and then uploaded it to phpMyAdmin. I am not sure why there was a error with a zip file.


  2. 0

    I believe that, while you modified the phpMyAdmin directive $cfg['MemoryLimit'], you may have not adjusted the PHP configuration values that also affect resource limits. You may wish to refer to the phpMyAdmin FAQ entry on the subject, which shows several php.ini directives you’ll also need to adjust. In your case, you’re hitting the max_execution_time limit, but you probably need to increase all of these:

    • max_execution_time,
    • upload_max_filesize,
    • memory_limit, and
    • post_max_size
    Login or Signup to reply.
Please signup or login to give your own answer.

Back To Top
Search