MySQLDumper-Board Forum Index Follow me on Twitter

Portal  •   Forum  •  Downloads  •  Profile  •  Search   •  Register  •  Log in to check your private messages  •  Log in  •  


 MySQLDumper: Fatal error: Maximum execution time of

Post new topicReply to topic
Author Message
ghundermark
knows MySQLDumper
knows MySQLDumper





Joined: 03 Dec 2011
Posts: 4


blank.gif

PostPosted: 2011-12-05, 05:44    MySQLDumper: Fatal error: Maximum execution time of Reply with quoteBack to top

Hello again,

So I've managed to build a pretty large database and now I'd like to back it up. Unfortunately, I'm getting a "Fatal error: Maximum execution time of 60 seconds exceeded in C:\xampp\htdocs\mysqldumper\inc\mysql.php on line 408" error whenever I try.

line 408 is

$res = mysql_query('OPTIMIZE TABLE `' . $row['Name'] . '`');


I did my homework as best as I could and tried your previously recommended fix of changing the speed control to 70 to 2000. I've also included a screenshot so that you can see if there are any glaring mistakes.

I've also tried to switch to backup another database via MySQLDumper and everything worked fine.

Any idea what could be wrong?

Image

OfflineView user's profileSend private message    
Anzeigen











Posted:    Anzeigen Back to top


    
Jens_K
Moderator
Moderator




Age: 37
Joined: 04 Sep 2007
Posts: 1710
Location: Nähe Bielefeld


germany.gif

PostPosted: 2011-12-05, 10:10    (No subject) Reply with quoteBack to top

Change the value for "Optimize Tables before Backup" to "not activated".

The Optimization takes too long so that the timout limit is reached.
You can optimize the tables manually with the SQL browser, but you will get timeouts there, too. Just keep optimizing until you get no more timeout.

_________________
It's like math-camp all over again ... not ... that i've ever been to math-camp!
mein Blog

OfflineView user's profileSend private messageVisit poster's website    
ghundermark
knows MySQLDumper
knows MySQLDumper





Joined: 03 Dec 2011
Posts: 4


blank.gif

PostPosted: 2011-12-13, 01:55    (No subject) Reply with quoteBack to top

Thanks. That worked! Smile
OfflineView user's profileSend private message    
Jens_K
Moderator
Moderator




Age: 37
Joined: 04 Sep 2007
Posts: 1710
Location: Nähe Bielefeld


germany.gif

PostPosted: 2011-12-13, 10:12    (No subject) Reply with quoteBack to top

Thank you for your reply. I'm glad it's ok now ...
_________________
It's like math-camp all over again ... not ... that i've ever been to math-camp!
mein Blog

OfflineView user's profileSend private messageVisit poster's website    
Display posts from previous:      
Post new topicReply to topic


 Jump to:   


Show permissions
Similar topics
Topic Author Forum Replies Posted
No new posts Perl Backup immer Error 404 luckyheiko Fehler / Probleme 6 2012-05-23, 10:06 View latest post
No new posts Serverumzug - von Hoster zu Hoster mi... soigroeg Allgemeine Fragen zu MySQLDumper 1 2012-05-21, 13:36 View latest post
No new posts Autodelete without visiting MySQLDump... DrewC Errors and questions 5 2012-04-13, 17:37 View latest post
No new posts Backup Error Vengeance66 Errors and questions 4 2012-04-02, 16:52 View latest post
No new posts MySQL-ERROR / nach phpmyadmin passwor... stone_22 MySQLDumper 1.24 4 2012-03-31, 00:40 View latest post

 
CrackerTracker © 2004 - 2012 CBACK.de

Powered by Orion based on phpBB © 2001, 2002 phpBB Group
CBACK Orion Style based on FI Theme
All times are GMT + 2 Hours

phpBB SEO