Fatal error

Hangin' Around Joined: Jul 21, 2004 Posts: 47

Hi !
When backing up my database from my host to install at home(using phpmyadmin)
I get the following error message when running the sql file at home:
Fatal error: Maximum execution time of 300 seconds exceeded in D:\minixampp\phpmyadmin\libraries\read_dump.lib.php on line 77

My database is about 4 mb in size so it takes a while...
If i manually "cut" the sql file in half it works fine,but doing the import 2 times
seems so unneccesary.
Please can someone tell me what to do ?
At home i use phpmyadmin v2.5.5-pl1
and my host v2.5.6
Dobbelina Very Happy

Posted: Thu Aug 19, 2004 7:11 am

You can increase the time in php.ini to something a little more reasonable.

Or do it from the command line. paste the sql file in the bin directory then open a command prompt navigate to the bin directory.
cd c:/mysql/bin or cd /d d:/minixampp/mysql/bin
mysql -uroot -ppassword Database > file.sql

Or there is another tool out there called mysqlfront that works great for importing.

Posted: Thu Aug 19, 2004 11:38 pm

Thanks for that tip !
I've changed to SQLyog, and it worked beatifully !
It went in,all in one go, thanks !
Dobbelina Very Happy