Hello, I'm reaching out because I'm unable to add .sql files to phpMyAdmin. The website loads for a good 5 minutes before crashing with this error. Any ideas? I've tried resetting the SQL settings, but it doesn't seem to help
Hey there! You're probably reaching an internal timeout of some sort, such as the ExecTimeLimit value, which is 3600 seconds (6 minutes) by default.
If the .sql file is large, you could easily exceed that time limit with normal work. You can manually edit the /usr/local/cpanel/base/3rdparty/phpMyAdmin/config.inc.php file to change this, although cPanel will overwrite those changes as part of the nightly update on the system. The top comment noted here explains how you can make those edits more permanent if this is a change you'd like to see stay in place on the system.
If the .sql file is large, you could easily exceed that time limit with normal work. You can manually edit the /usr/local/cpanel/base/3rdparty/phpMyAdmin/config.inc.php file to change this, although cPanel will overwrite those changes as part of the nightly update on the system. The top comment noted here explains how you can make those edits more permanent if this is a change you'd like to see stay in place on the system.
Can you check the cPanel error log (/usr/local/cpanel/logs/error_log) after making that error happen and see if there is anything useful there?
| Thread starter | Similar threads | Forum | Replies | Date |
|---|---|---|---|---|
| M | phpMyAdmin Internal Server Error 500 | Databases | 1 | |
| L | phpmyadmin 500 internal server error when accessed from users cpanel | Databases | 4 | |
| V | PHPMYADMIN 500 error while importing | Databases | 4 | |
| N | phpmyadmin 500 internal error | Databases | 4 | |
| A | phpMyAdmin - Internal Server Error 500 | Databases | 1 |