FRIHOST FORUMS SEARCH FAQ TOS BLOGS COMPETITIONS
You are invited to Log in or Register a free Frihost Account!


problem in sql and importing db.





v3nd0r
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.
Wink

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.
Wink


It works for me. Thanks for the link!!
Related topics
I can't upload my Database SQL script ! Helllppppp!!!!
MySQL DB Backup script - minor problem
reading from sql db
How to edit SQL files?
.sql problem
membersystem with profile. 80 frih$ to the one who got me 1!
Problem with a script
How to create a simple database based website?
sql problem
SQL ERROR [ mysql4 ] - due to hosting? -
Problem with my SQL Server (not Frihost)
Open Office Calc Macros
Retrieving Loads of Info Efficiently
Adobe Premiere folks...
Reply to topic    Frihost Forum Index -> Support and Web Hosting -> Web Hosting Support

FRIHOST HOME | FAQ | TOS | ABOUT US | CONTACT US | SITE MAP
© 2005-2011 Frihost, forums powered by phpBB.