flandercan Posted October 19, 2003 Share Posted October 19, 2003 Hi folks, I have made a backup of a freinds sql database from the phpmyadmin console. He doesnt have a shell access at all as its a hosted server, when i try to upload or restore the data i get the following error Fatal error: Maximum execution time of 300 seconds exceeded in /usr/local/cpanel/base/3rdparty/phpMyAdmin/libraries/read_dump.lib.php From what i have read its because the backup.sql file is to big and some articles have advised to chop the file up and upload in chinks, well my question is, can i just chop the file up or does the file need header information at the top of each file..... or is there a better way??? thanks Paul Quote Link to comment https://forums.phpfreaks.com/topic/1180-phpmyadmin-problem/ Share on other sites More sharing options...
George_hu Posted October 19, 2003 Share Posted October 19, 2003 Back up table by table may solution for this. However this is not always fit. Try \"MySQL Commander\" include BiGtable feature which allow to backup huge db. Quote Link to comment https://forums.phpfreaks.com/topic/1180-phpmyadmin-problem/#findComment-3972 Share on other sites More sharing options...
flandercan Posted October 19, 2003 Author Share Posted October 19, 2003 The guy has dropped his old server so we no longer have access to the db other than the huge backup...... thanks paul Quote Link to comment https://forums.phpfreaks.com/topic/1180-phpmyadmin-problem/#findComment-3977 Share on other sites More sharing options...
flandercan Posted October 19, 2003 Author Share Posted October 19, 2003 I tried a few things and this worked, I split the file into 500k chunks by line although it takes some time to import them it does work the command i used was split --line-bytes=500k backup.sql file_.sql thanks paul Quote Link to comment https://forums.phpfreaks.com/topic/1180-phpmyadmin-problem/#findComment-3978 Share on other sites More sharing options...
yrrahxob Posted November 9, 2003 Share Posted November 9, 2003 You might want to try this set_time_limit ( int seconds) Set the number of seconds a script is allowed to run. If this is reached, the script returns a fatal error. The default limit is 30 seconds or, if it exists, the max_execution_time value defined in the php.ini. If seconds is set to zero, no time limit is imposed. Quote Link to comment https://forums.phpfreaks.com/topic/1180-phpmyadmin-problem/#findComment-4416 Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.