1. No Profile Picture
    Junior Member
    Devshed Newbie (0 - 499 posts)

    Join Date
    Mar 2000
    Rep Power
    I'm trying to move a database from one machine to another by doing a mysql dump in phpMyAdmin and get a message in the last line of the sql file " Fatal error: Maximum execution time exceeded in lib.inc.php3 on line 287. Does anyone know how to increase the maximum time?
  2. #2
  3. No Profile Picture
    Contributing User
    Devshed Newbie (0 - 499 posts)

    Join Date
    Jun 2000
    Rep Power
    In PHP default is 30 seconds maximum for a script to run. You can extend it with:

    set_time_limit(number of seconds);

    set_time_limit(0); // no time limit: forever

    set_time_limit(600); // allow execution for 10 minutes max.
    The reason a time limit is imposed? I guess so you don't have to re-boot the system.
    Suppose you had a bug in a loop that ran forever. Your site would be down unless you either kill the process or re-boot. Hope this helps you out.


Similar Threads

  1. Invalid characters with PHP and MySQL
    By gio50000 in forum MySQL Help
    Replies: 2
    Last Post: November 18th, 2004, 08:59 AM
  2. mysql dump to text file or excel?
    By numb in forum PHP Development
    Replies: 2
    Last Post: December 14th, 2003, 01:23 PM
  3. PHP 101 (part 4) - Look, Ma...It's Alive!
    By guest in forum Development Articles
    Replies: 75
    Last Post: November 26th, 2003, 08:22 AM
  4. Errcode:13 . How to solve it on MySQL + Windows 2000
    By hankycheng in forum MySQL Help
    Replies: 28
    Last Post: August 3rd, 2003, 10:05 AM
  5. Can't connect to mysql
    By pacman in forum MySQL Help
    Replies: 2
    Last Post: February 28th, 2003, 12:46 AM

IMN logo majestic logo threadwatch logo seochat tools logo