Portal Home > Knowledgebase > Articles Database > PHPMYADMIN Error
PHPMYADMIN Error
| Posted by MrJosh, 08-02-2009, 07:36 AM |
| Hi,
Im 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.
Im just wondering if there is any way to edit this 300 seconds and lets say change it to 1000000 seconds for the time being whilst Im trying to restore it, if not, is there an alternative way I could upload this database? Just to add Im operating cPanel/WHM.
Kind Regards,
Josh
|
| Posted by eeg3, 08-02-2009, 07:44 AM |
| You will need to increase the Timeout in Apache to a longer time period. Alternatively, you could just import it from the command line.
|
| Posted by Dark Light, 08-02-2009, 07:45 AM |
| 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.
|
| Posted by bear, 08-02-2009, 07:52 AM |
| Best way is to use shell, IMHO.
|
| Posted by MrJosh, 08-02-2009, 07:54 AM |
| 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?
|
| Posted by bear, 08-02-2009, 08:00 AM |
| Look up one post?
|
| Posted by Dark Light, 08-02-2009, 08:10 AM |
| bear's explanation covers it pretty well.
|
| Posted by MrJosh, 08-02-2009, 08:11 AM |
| Ahh right thanks! Didn't see that post .
|
Add to Favourites 
Print this Article
Also Read
