Phpmyadmin database upload issues

[Xavier12]

Hey guys,

We are having an issue upload a 300mb mysql database to phpmyadmin.. With direct mysql file, t stops and only copies a few tables, stating to reupload to continue (which it doesn't and states that there are pre-existing tables). With zip file, it does the same.. at one point at 504 error occurred.

A customers site is down because of this. Please advise, thanks.

 

[UFHH01]

Hi Xavier12,

please see as a quick and dirty work-around: https://talk.plesk.com/threads/importing-large-sql-file-via-ssh.332624/#post-778081 after you uploaded the dump per FTP.


Afterwards please have a look at: https://talk.plesk.com/threads/mysql-1-6gb-backup-help.332558/#post-778433 and decide for yourself, if such a tool could avoid such issues.

 

[Xavier12]

Hi UFHH01

Thanks for reaching back quickly. Going the command line route for now as mentioned. A part from that, how can we resolve the issue with phpmyadmin to upload via the console without any issues with php script timeout, 504 issues or part of the tables uploading?

Please advise, thanks

 

[UFHH01]

Hi Xavier12,

please increase your settings at "fcgid.conf" for your apache webserver from the standard "45" seconds to something like "3600" seconds.
It could be as well a good idea to increase some standard php - settings ( max_execution_time, max_input_time, upload_size, etc. ... in your php.ini's located on your server, to avoid your described issue ).

... or/and add/edit your "config.inc.php" for phpMyAdmin, located at: "/opt/psa/admin/htdocs/domains/databases/phpMyAdmin" ( but be aware that updates/upgrades/patches may re-change your settings! ). The standard settings are:

$cfg['ExecTimeLimit'] = 300;

and you could change it to:​

$cfg['ExecTimeLimit'] = 0;​

 

[Xavier12]

Thanks UFHH01, greatly appreciate it.