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.

Mysql error importing large db

Discussion in 'Database Discussions' started by Don7t, Jan 9, 2005.

  1. Don7t

    Don7t Member

    Joined:
    Mar 8, 2004
    Messages:
    24
    Likes Received:
    0
    Trophy Points:
    1
    Keep getting this error when trying import some db's, the smaller files work fine, they are all gzipped.

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

    How do I open up the 300 second time limit? I have several large db's I need to import and have tried some suggestions from these forums with no luck.

    Thanks
     
  2. dezignguy

    dezignguy Well-Known Member

    Joined:
    Sep 26, 2004
    Messages:
    534
    Likes Received:
    0
    Trophy Points:
    16
    Use the mysql tools on the commandline to import large databases... you shouldn't be using phpmyadmin for large databases. The command-line is much faster too!

    Read the mysql documentation for the proper syntax to use for importing a n sql into a database. Once you get it typed up properly once, you should be able to just copy and paste the one line while making small changes to the import filename, etc. It's not as hard as it might sound.
     
  3. Don7t

    Don7t Member

    Joined:
    Mar 8, 2004
    Messages:
    24
    Likes Received:
    0
    Trophy Points:
    1
    Your right, that is much faster, thanks......
     
Loading...

Share This Page