Please whitelist cPanel in your adblocker so that you’re able to see our version release promotions, thanks!

The Community Forums

Interact with an entire community of cPanel & WHM users!

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:
    166
    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:
    166
    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.
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
  3. celliott

    celliott Well-Known Member

    Joined:
    Jan 2, 2006
    Messages:
    460
    Likes Received:
    0
    Trophy Points:
    166
    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:
    166
    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.
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
Loading...

Share This Page

  1. This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
    By continuing to use this site, you are consenting to our use of cookies.
    Dismiss Notice