issue have seen for years with uploading database

dmacleo

dmacleo

Verified User
Joined
Jun 21, 2012
Messages
631
Upload a Database Backup (.gz)
browse and select, click upload and on every browser get The connection to the server was reset while the page was loading.
this has been issue for me for many versions and cent os 6 (and all .x versions, started with 6.0) and centos 7.x now.
not sure where to look for logs on this.
I usually use phpmyadmin so never really cared to mention it but figured I should at some point.
has been issue on php 5.3 onwards and all php handlers.
was issue when using nginx and nginx-proxy also.
 
your problem must solve from php.ini. set better values for : upload and post max size allowed!
 
may be you are using fastcgi as php handler. So you must config file size in its setting too.

best solution is to check your webhosting account error logs.
 
Because it is managed by PHP variables, as already replyed.

Default value are made to prevent server overload, so, a big DB upload will keep a service running on one request and consume resources, that's why is better use command line when importing big databases.

So, you have two options, tweak php.ini to match your needs (and i would suggest to restore nice values once done), or use command line.

Is not a CentOS problem
Is not a NGINX problem
Is not a phpMyAdmin problem
Is not a MySQL problem
Is not a PHP problem

Is not A problem, is a security thing.

Regards
 
as stated it happens with all php handlers.
it happens on fresh install (even 2 days ago) of DA with default settings chosen and no tweaks.
test file being used is 5mb, basically an empty DB created just to test this.
thought at first was possibly csf issue so last test was done w/o it being installed.
server load not an issue for me, only 3 sites on it and all are mine. I use DA to maintain my own domains nobody else on server.
only 1 php version on server, does DA interface use that ini file or is there a separate one the DA interface uses itself?
 
create a phpinfo file and fine your server php.ini file stated in its results.

tweak the values related to upload and post size and execution time in this php.ini file.

there is nothing more and must have no problem!
 
shivahost said:
create a phpinfo file and fine your server php.ini file stated in its results.

tweak the values related to upload and post size and execution time in this php.ini file.

there is nothing more and must have no problem!
Click to expand...
yeah already done that was thinking maybe the DA interface itself had a distinct ini file but not seeing anything.
will nuke a vps this afternoon and test more. see if maybe php 54 or 55 are ok.
like I said, stock install using default php and handler (as well as all others) does it using a 5mb test file (unzipped the sql file approx 30mb) and (for me) mhas acted this way for 2+ years, since I started using DA starting with centos 6.0 and all iterations up to and including present 7.2.1511
 
That's the strange point, i'm using DA+CentOS since about 6 years and never had such a problem, and DA itself is compiled on it, so actually the main "more-accurate" tests are done on CentOS...

What about apache error logs?
 
SeLLeRoNe said:
That's the strange point, i'm using DA+CentOS since about 6 years and never had such a problem, and DA itself is compiled on it, so actually the main "more-accurate" tests are done on CentOS...

What about apache error logs?
Click to expand...

have not (yet) seen anything in httpd log, and I expected I should.
almost if never handed off to apache.
will know more tonight after I get a base stock set back up.
 
You must log in or register to reply here.
Back
Top