The Community Forums

Interact with an entire community of cPanel & WHM users!
  1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.

Error when restoring mysql dump file

Discussion in 'General Discussion' started by celliott, Feb 2, 2006.

  1. celliott

    celliott Well-Known Member

    Joined:
    Jan 2, 2006
    Messages:
    460
    Likes Received:
    0
    Trophy Points:
    16
    Location:
    United Kingdom
    I am restoring a MySQL dump file which at 9MB is fairly big.

    When restoring this in phpmyadmin and the file has been uploaded I am getting the following error message:

    Fatal error: Maximum execution time of 300 seconds exceeded in /usr/local/cpanel/base/3rdparty/phpMyAdmin/libraries/read_dump.lib.php on line 91

    Anyone have any suggestions of how I could get around this issue?

    Thanks
     
  2. Murtaza_t

    Murtaza_t Well-Known Member

    Joined:
    Jan 24, 2005
    Messages:
    476
    Likes Received:
    0
    Trophy Points:
    16
    Location:
    Earth
    cPanel Access Level:
    Website Owner
    Well you will not be able to restore a database which is more than 2MB from Phpmyadmin, its better that you do it from shell. and regarding your error, "max_execution_time" value is set in php.ini, normal value is 30 sec, yours is already 10 times of it so its better that you do it from shell.
     
  3. celliott

    celliott Well-Known Member

    Joined:
    Jan 2, 2006
    Messages:
    460
    Likes Received:
    0
    Trophy Points:
    16
    Location:
    United Kingdom
    How would i go about restoring this in shell?
     
  4. Murtaza_t

    Murtaza_t Well-Known Member

    Joined:
    Jan 24, 2005
    Messages:
    476
    Likes Received:
    0
    Trophy Points:
    16
    Location:
    Earth
    cPanel Access Level:
    Website Owner
    login as root on your server and run this command :
    Code:
    ]# mysql -u database_user -p database_name < /path/to/.sql_backup_file
    It will ask you for a password, you need to give the password of the datababe_user.
     
Loading...

Share This Page