500 Internal Server Error while importing a database with CPU/RAM remaining engaged

Support and Discussion
1

Hi there,

I increased max execution time for both PHP and PhpMyAdmin.

I was trying to import a database of 800 MB and few minutes later I received the following error:

500
Internal Server Error
An internal server error has occured.

But the interesting part is that the CPU and RAM usage stayed basically at top level 90-100%. Is it possible that the process was still continuing though the error was on the screen? It looked like the database server was still busy and remained busy till I stopped it.

1x CPU
1 GB RAM
Current Version: 2.3
Build: 4
Latest Version: 2.3
Latest Build: 4

2

Hello.
Same problem. Found a solution?

3

Not quite. But one thing to notice - click on Panel menu PHP>Edit PHP Configs. Select a version that phpMyAdmin runs on. Most likely it’s PHP 8.0. You have to increase some configs like max_execution_time, upload_max_filesize, post_max_size…

Other option is to try uploading gzip/zip format file.

4

This has already been done.

I even increased the limit on PhpMyAdmin itself.
/usr/local/CyberCP/public/phpmyadmin/config.inc.php
$cfg[‘ExecTimeLimit’] = 0;

But after 1 hour, the database is still not imported entirely. And the process is forcibly interrupted.

Where does the webserver save the 500 error log for PhpMyAdmin? I can’t find the error.log for phpmyadmin.
Can you give me some advice?