| Author |
Message |
HerculePoirot
knows MySQLDumper
Joined: 26 Apr 2010
Posts: 2
|
 Posted:
2010-04-26, 15:06 error when restoring phpbb3 database |
  |
Fatal error: Maximum execution time of 60 seconds exceeded in C:\xampp\htdocs\mysqldump2\mysqldumper\restore.php on line 123
i got those errors when trying to restore my forum database.
this is happening for sometime now... and even when i tried at the hosting using mysqldumper, i got the same error. any idea why?
i cant figure it out what's the cause of this.
btw i also backup it using mysqldumper but without a single problem.
please help.
Thanks.
|
|
   |
|
Anzeigen
|
|
Posted:
Anzeigen |
|
|
| |
|
DSB
Developer
Age: 41
Joined: 30 Apr 2004
Posts: 16067
Location: Reichenberg bei Würzburg
|
|
Posted:
2010-04-26, 19:58 (No subject) |
|
What version are you using?
In the actual version 1.24 it is impossible to get a timeout in line 123.
_________________
Gruß / Greetings, DSB
Teigwaren heißen Teigwaren, weil sie Teig waren.
Diejenigen, die lautstark darüber diskutieren, warum es nicht geht, mögen bitte jene nicht stören, die es gerade tun.
|
|
  |
|
HerculePoirot
knows MySQLDumper
Joined: 26 Apr 2010
Posts: 2
|
|
Posted:
2010-04-27, 05:08 (No subject) |
|
yes i'm using version 1.24, when backup and restore.
is there any way to fix this?
thanks.
|
|
| |
|
DSB
Developer
Age: 41
Joined: 30 Apr 2004
Posts: 16067
Location: Reichenberg bei Würzburg
|
|
Posted:
2010-04-27, 05:27 (No subject) |
|
At the moment I have no idea what could cause this.
Could you send me your backup? I would try to reproduce this.
_________________
Gruß / Greetings, DSB
Teigwaren heißen Teigwaren, weil sie Teig waren.
Diejenigen, die lautstark darüber diskutieren, warum es nicht geht, mögen bitte jene nicht stören, die es gerade tun.
|
|
| |
|
Slackervaara
uses MSD regulary
Joined: 23 Apr 2008
Posts: 11
|
|
Posted:
2011-10-06, 20:02 (No subject) |
|
I got identical problem with latest Xampp and a database with phpBB3 and MySQLDumper 1.23. The restore halted at phpbb_posts. However, I discovered that from the commandline in Windows one can import databases faster than MySQLDumper and also errors can be suppressed that normally halts import.
Open a commandwindows in Windows write:
C:\xampp\mysql\bin\mysql -u root databasename < full path to sql-file
If you get errors and halt at phpbb_search_wordmatch, which I did try again with:
C:\xampp\mysql\bin\mysql -u root databasename --force < full path to sql-file
I GB sql file (100 MB gz compressed) took one hour to import on a 6 year old PC.
|
|
| |
|
DSB
Developer
Age: 41
Joined: 30 Apr 2004
Posts: 16067
Location: Reichenberg bei Würzburg
|
|
Posted:
2011-10-06, 20:07 (No subject) |
|
Of course the command line is faster than any PHP application that lives in a restricted environment.
But why do you use version 1.23? The actual version is 1.24.4 and we improved a lot since version 1.23.
So you could give it a new try. 
_________________
Gruß / Greetings, DSB
Teigwaren heißen Teigwaren, weil sie Teig waren.
Diejenigen, die lautstark darüber diskutieren, warum es nicht geht, mögen bitte jene nicht stören, die es gerade tun.
|
|
| |
|
Slackervaara
uses MSD regulary
Joined: 23 Apr 2008
Posts: 11
|
|
Posted:
2011-10-06, 20:37 (No subject) |
|
Sorry, I wrote wrong version number I use MySQLDumper 1.24.3.
|
|
| |
|
DSB
Developer
Age: 41
Joined: 30 Apr 2004
Posts: 16067
Location: Reichenberg bei Würzburg
|
|
Posted:
2011-10-06, 20:43 (No subject) |
|
Ok.
So if it halts at phpbb_posts, you might have set the speed limits to high.
Try lowering the params for the speed limit.
_________________
Gruß / Greetings, DSB
Teigwaren heißen Teigwaren, weil sie Teig waren.
Diejenigen, die lautstark darüber diskutieren, warum es nicht geht, mögen bitte jene nicht stören, die es gerade tun.
|
|
| |
|
Slackervaara
uses MSD regulary
Joined: 23 Apr 2008
Posts: 11
|
|
Posted:
2011-10-09, 07:55 (No subject) |
|
Yesterday, I tried the identical database and files in Xampp for Linux. I had then no problem what so ever with MySQLDumper, which was at least double as fast as in Windows. It seems as the problem only occurs with Xampp for Windows.
|
|
| |
|
DSB
Developer
Age: 41
Joined: 30 Apr 2004
Posts: 16067
Location: Reichenberg bei Würzburg
|
|
Posted:
2011-10-09, 12:28 (No subject) |
|
« DSB » wrote: Try lowering the params for the speed limit.
Did you try what I suggested?
_________________
Gruß / Greetings, DSB
Teigwaren heißen Teigwaren, weil sie Teig waren.
Diejenigen, die lautstark darüber diskutieren, warum es nicht geht, mögen bitte jene nicht stören, die es gerade tun.
|
|
| |
|
Slackervaara
uses MSD regulary
Joined: 23 Apr 2008
Posts: 11
|
|
Posted:
2011-10-09, 17:36 (No subject) |
|
I have tried to decrease the velocity first to 20000 and then to 5000, but the error persists and the restore stops at phpbb_posts.
|
|
| |
|
DSB
Developer
Age: 41
Joined: 30 Apr 2004
Posts: 16067
Location: Reichenberg bei Würzburg
|
|
Posted:
2011-10-09, 18:10 (No subject) |
|
Did you check Xampp's PHP error_log?
_________________
Gruß / Greetings, DSB
Teigwaren heißen Teigwaren, weil sie Teig waren.
Diejenigen, die lautstark darüber diskutieren, warum es nicht geht, mögen bitte jene nicht stören, die es gerade tun.
|
|
| |
|
Slackervaara
uses MSD regulary
Joined: 23 Apr 2008
Posts: 11
|
|
Posted:
2011-10-09, 18:19 (No subject) |
|
Yes, the error message were: Maximum execution time of 300 seconds exceeded
Exactly as previously.
|
|
| |
|
DSB
Developer
Age: 41
Joined: 30 Apr 2004
Posts: 16067
Location: Reichenberg bei Würzburg
|
|
Posted:
2011-10-09, 18:37 (No subject) |
|
Was the dump you want to import made using MySQLDumper?
_________________
Gruß / Greetings, DSB
Teigwaren heißen Teigwaren, weil sie Teig waren.
Diejenigen, die lautstark darüber diskutieren, warum es nicht geht, mögen bitte jene nicht stören, die es gerade tun.
|
|
| |
|
Slackervaara
uses MSD regulary
Joined: 23 Apr 2008
Posts: 11
|
|
Posted:
2011-10-09, 21:34 (No subject) |
|
Yes, it was created with identical version of MySQLDumper.
|
|
| |
|
|
|
