Results 1 to 8 of 8

Hybrid View

  1. #1
    Join Date
    Jul 2008
    Location
    United Kingdom
    Posts
    149

    PHPMYADMIN Error

    Hi,

    I’m trying to restore a clients MYSQL database (10 MB) via PHPMYADMIN, however when it gets half way through I get a fatal error expiring time message at 300 seconds.

    I’m just wondering if there is any way to edit this 300 seconds and let’s say change it to 1000000 seconds for the time being whilst I’m trying to restore it, if not, is there an alternative way I could upload this database? Just to add I’m operating cPanel/WHM.

    Kind Regards,
    Josh

  2. #2
    Join Date
    Jul 2009
    Location
    Charlotte, NC
    Posts
    42
    You will need to increase the Timeout in Apache to a longer time period. Alternatively, you could just import it from the command line.

  3. #3
    Join Date
    Oct 2005
    Location
    UK
    Posts
    552
    Use mysql from the command line to import that much data.

    SSH into your server, login to mysql from the command line as the database user and then run your SQL query or import function as you would have done from PHPMyAdmin, but from the command line.

  4. #4
    Join Date
    Jul 2008
    Location
    United Kingdom
    Posts
    149
    Quote Originally Posted by eeg3 View Post
    You will need to increase the Timeout in Apache to a longer time period. Alternatively, you could just import it from the command line.
    Thanks for your reply. Where can I find this? I've checked through the Apache configuration and there's nothing there which states 300 seconds (which is shown in the error message).

    Quote Originally Posted by Dark Light View Post
    Use mysql from the command line to import that much data.

    SSH into your server, login to mysql from the command line as the database user and then run your SQL query or import function as you would have done from PHPMyAdmin, but from the command line.
    Thanks for your reply. I've never done this before (via command line), would it be possible for you to explain how?

  5. #5
    Join Date
    Oct 2002
    Location
    /roof/ledge
    Posts
    28,088
    Quote Originally Posted by ManiaHost View Post
    Thanks for your reply. I've never done this before (via command line), would it be possible for you to explain how?
    Look up one post?
    Your one stop shop for decentralization

  6. #6
    Join Date
    Oct 2005
    Location
    UK
    Posts
    552
    bear's explanation covers it pretty well.

  7. #7
    Join Date
    Jul 2008
    Location
    United Kingdom
    Posts
    149
    Quote Originally Posted by bear View Post
    Look up one post?
    Ahh right thanks! Didn't see that post .

  8. #8
    Join Date
    Oct 2002
    Location
    /roof/ledge
    Posts
    28,088
    Best way is to use shell, IMHO.
    Code:
    mysql -u cpaneluser_dbusername -ppassword cpaneluser_dbname < dump.sql
    Your one stop shop for decentralization

Similar Threads

  1. PHPMyAdmin Error
    By Shib in forum VPS Hosting
    Replies: 7
    Last Post: 07-26-2009, 10:22 AM
  2. phpmyadmin error
    By VPS Max in forum Hosting Security and Technology
    Replies: 9
    Last Post: 12-14-2008, 08:52 PM
  3. Phpmyadmin error in whm
    By Klentelaris in forum Hosting Security and Technology
    Replies: 4
    Last Post: 07-15-2008, 02:07 AM
  4. phpmyadmin error
    By XMLxp in forum Hosting Security and Technology
    Replies: 1
    Last Post: 07-01-2006, 03:22 PM
  5. phpMyAdmin error
    By JDTurbeville in forum Programming Discussion
    Replies: 1
    Last Post: 05-24-2003, 03:52 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •