Applicable to:
- Plesk for Linux
- Plesk for Windows
Symptoms
When trying to upload a database in phpMyAdmin more than 500M, getting the error.
PLESK_ERROR: Script timeout passed, if you want to finish import, please resubmit same file and import will resume.
CONFIG_TEXT: ERROR: Maximum execution time of 300 seconds exceeded (DBIMysqli.php:262)
CONFIG_TEXT: localhost:8443/domains/databases/phpMyAdmini/export.php
The site cannot be reached
The webpage at https://localhost:8443/domains/databases/phpMyAdmini/export.php might be temporarily down or it may have moved permanantly to a new web address
Err_Invalid_response
The file %plesk_dir%admin\logs\php_error.log contains the following record at the same time:
CONFIG_TEXT: PHP Fatal error: Maximum execution time of 300 seconds exceeded in C:\Program Files (x86)\Plesk\admin\htdocs\domains\databases\phpMyAdmin\libraries\classes\Dbi\DbiMysqli.php
Cause
The error occurs because of a huge file and the restoration process fails with timeout.
Resolution
Starting from Plesk 12.5, it is possible to import databases via Plesk.
Browse to Home > Domains > example.com > Databases and use importing functionality:
If it does not fit some needs proceed with the following solutions.
Increase the 'ExecTimeLimit' value:
Linux:
-
Login to the server over SSH
-
Create the file
config.inc.php.
For Plesk Onyx and Plesk Obsidian below 18.0.30:# cp -p /usr/local/psa/admin/htdocs/domains/databases/phpMyAdmin/libraries/config.default.php /usr/local/psa/admin/htdocs/domains/databases/phpMyAdmin/config.inc.php
For Plesk Obsidian 18.0.30 and above:
# cp -p /usr/local/psa/phpMyAdmin/libraries/config.default.php /usr/local/psa/phpMyAdmin/config.inc.php
-
Increase the value of
$cfg['ExecTimeLimit']inconfig.inc.phpcreated on step 2:CONFIG_TEXT: $cfg['ExecTimeLimit'] = 3600;
-
Increase the settings in
/etc/sw-cp-server/configto avoid '504 Gateway Timeout' error:CONFIG_TEXT: fastcgi_read_timeout 3600;
fastcgi_send_timeout 3600; -
Restart sw-cp-server:
# service sw-cp-server restart
Note: if the issue still persist, the browser cache should be cleared.
Windows:
-
Login to the server over RDP.
-
Create the file
config.inc.php
For Plesk Onyx and Plesk Obsidian below 18.0.30:
Copy the content of%plesk_dir%admin\htdocs\domains\databases\phpMyAdmin\libraries\config.default.phpto%plesk_dir%admin\htdocs\domains\databases\phpMyAdmin\config.inc.php.For Plesk Obsidian 18.0.30 and above:
Copy the content of%plesk_dir%phpmyadmin\libraries\config.default.phpto%plesk_dir%phpmyadmin\config.inc.php. -
Increase the value of
$cfg['ExecTimeLimit']inconfig.inc.phpcreated on step 2:CONFIG_TEXT: $cfg['ExecTimeLimit'] = 3600;
Upload the database via command prompt:
Linux:
-
Login to the server over SSH.
-
Upload the database dump to the server (any of the convenient ways).
-
Restore the database:
# MYSQL_PWD=`cat /etc/psa/.psa.shadow` mysql -uadmin db_name < /path/to/database_dump
Windows:
-
Login to the server over RDP.
-
Upload the database dump to the server.
-
Restore the database:
C:\> "%plesk_dir%MySQL\bin\mysql.exe" -u DBUSER -p******** -P 3306 DATABASENAME < .\path\to\mysql_backup.sql
Comments
0 comments
Please sign in to leave a comment.