Fatal error: Maximum execution time of 300 seconds exceeded in /usr/local/cpanel/base/3rdparty/phpMyAdmin/libraries/read_dump.lib.php on line 91

I get this error when i try to import db. Db is uploading it's ok, db is upoaled and nothing is happening and after 300 sec i get timeout msg. I don't have any idea why i get it. Some time i can import some tabels for backup db but some time i import nothing. Any help?

sean

300sec exceed? how big is your database?
if it's big, split db to 3 or 4 files and retry.

Bondings

Sorry, I have no idea what might be the problem. Maybe someone else will know it.

mOrpheuS

most likely the db dump file is too big to be uploaded/executed within the given timeout limit.
you can try splitting it into separate smaller (~5000 lines at a time) pieces and executing them one by one. (hopefully, you should get by this way)

also, some people claim this to have worked for them - http://www.ozerov.de/bigdump.php
I'm not sure how it works...but you might want to give it a try as a last resort.

p.s. - I have also had some timeout problems when accessing phpmyadmin using https (port 2083)...if you are using that, I'll suggest switching back to plain old non secure 2082.

v3nd0r

my db is 5MB it's in 1 file. I start uploading it, holl db is uploaded [5MB] and phpmyadmin is not responding then ,my computer is not sending any thing becaus it has send all db and then 300 sec and i get this error.

rvec

mOrpheuS wrote:

some people claim this to have worked for them - http://www.ozerov.de/bigdump.php
I'm not sure how it works...but you might want to give it a try as a last resort.