restore db time out problem

myyis
myyis used Ask the Experts™
on
Hi,
When I try to restore a db backup (40Mb zipped), It takes around 5 mins to upload and  then around 2 mins later I got this error

Internal Server Error 500 The cPanel Server operation timed out at cpsrvd.pl line 541.

I changed

max_execution_time=9000
cPanel PHP max execution time=9000

but it did not help. Any ideas?
Thank you.
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Most Valuable Expert 2017
Distinguished Expert 2018

Commented:
I don't have an answer for you but I moved away from CPanel / PHPMyAdmin updates some time ago for this (and other) reasons.

Now I use SQLYog to do the import of data.

Two scenarios
1. Remote server allows LOAD LOCAL - in which case I simply load the backup directly
2. Remote server does not allow LOAD LOCAL - in which case I restore to a local DB and then use SQLYog to replicate the database to the remote.

Author

Commented:
I found out that when I restore within WHM  (not cpanel) it worked.

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial