Results 1 to 8 of 8
Thread: PHPMYADMIN Error
Hybrid View
-
08-02-2009, 07:36 AM #1Temporarily Suspended
- 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
-
08-02-2009, 07:44 AM #2Junior Guru Wannabe
- 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.
-
08-02-2009, 07:45 AM #3Web Hosting Master
- 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.
-
08-02-2009, 07:54 AM #4Temporarily Suspended
- Join Date
- Jul 2008
- Location
- United Kingdom
- Posts
- 149
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).
Thanks for your reply. I've never done this before (via command line), would it be possible for you to explain how?
-
08-02-2009, 08:00 AM #5
-
08-02-2009, 08:10 AM #6Web Hosting Master
- Join Date
- Oct 2005
- Location
- UK
- Posts
- 552
bear's explanation covers it pretty well.
-
08-02-2009, 08:11 AM #7Temporarily Suspended
- Join Date
- Jul 2008
- Location
- United Kingdom
- Posts
- 149
-
08-02-2009, 07:52 AM #8
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
-
PHPMyAdmin Error
By Shib in forum VPS HostingReplies: 7Last Post: 07-26-2009, 10:22 AM -
phpmyadmin error
By VPS Max in forum Hosting Security and TechnologyReplies: 9Last Post: 12-14-2008, 08:52 PM -
Phpmyadmin error in whm
By Klentelaris in forum Hosting Security and TechnologyReplies: 4Last Post: 07-15-2008, 02:07 AM -
phpmyadmin error
By XMLxp in forum Hosting Security and TechnologyReplies: 1Last Post: 07-01-2006, 03:22 PM -
phpMyAdmin error
By JDTurbeville in forum Programming DiscussionReplies: 1Last Post: 05-24-2003, 03:52 AM