cannot import mysql database

boxcar · March 3rd, 2008, 4:44 PM

I am trying to upload a mysql database to my site. I am getting this error:

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

Any ideas what is wrong?

H · March 3rd, 2008, 5:14 PM

You're probably uploading a rather large SQL dump. You can either use php.ini to increase the timeout limit (may not work... CPanel uses a different PHP config if I recall) or upload the file to your server and use SSH to import (ideal) or upload the file and have support import the file or use a script to break up the imports and do it in chunks.

**Dan** · March 3rd, 2008, 5:33 PM

Quote:

Originally Posted by H

upload the file and have support import the file

Probably going to be your best bet in this situation. Just make sure you let us know the database name so we can import it through SSH

boxcar · March 3rd, 2008, 6:22 PM

What is a large dump?

My files in 2.2.MB uncompressed.

H · March 3rd, 2008, 7:34 PM

Hmm. That *shouldn't* be an issue. I think support might be the route to go though... even if just to find out why a 2.2MB file is exceeding the execution time.

boxcar · March 3rd, 2008, 7:46 PM

Support did restore my database so it is working now. The offered the suggestion that such trouble is "usually due to a slow connection on upload".

I tried uploading the file compressed (36k) and uncompressed (2.2MB) but it timed out in both cases. Methinks there is possibly something else going on but at least it is working now.

Thanks for your replies.

Gamer.Saga · March 3rd, 2008, 7:55 PM

Take the mysql file and do it bit by bit? Open it up in your beloved text editor and take and do it one table at a time, if you want to do it here and now. It takes up a lot of time, but it works.

**Dan** · March 3rd, 2008, 9:40 PM

Quote:

Originally Posted by Gamer.Saga

Take the mysql file and do it bit by bit? Open it up in your beloved text editor and take and do it one table at a time, if you want to do it here and now. It takes up a lot of time, but it works.

Yeah, you may have been able to do this with the whole file. Sometimes putting the commands straight into phpMyAdmin goes quicker then uploading/executing.

But like you found out, we're always here to help you if all else fails

March 3rd, 2008, 4:44 PM	#1 (permalink)
boxcar Registered User Fresh Surpasser Joined in Feb 2008 4 posts Gave thanks: 0 Thanked 0 times	cannot import mysql database I am trying to upload a mysql database to my site. I am getting this error: Fatal error: Maximum execution time of 300 seconds exceeded in /usr/local/cpanel/base/3rdparty/phpMyAdmin/libraries/string_mb.lib.php on line 47 Any ideas what is wrong?

March 3rd, 2008, 7:55 PM	#7 (permalink)
Gamer.Saga php, wha?! Comfy Contributor Joined in Feb 2008 163 posts Gave thanks: 4 Thanked 5 times	Take the mysql file and do it bit by bit? Open it up in your beloved text editor and take and do it one table at a time, if you want to do it here and now. It takes up a lot of time, but it works. __________________ HD.C \| MyTwitter I am addicted to LINUX.

Thread Tools	Search this Thread
Show Printable Version Email this Page	Search this Thread: Advanced Search
Rate This Thread
Rate This Thread:

March 3rd, 2008, 5:14 PM	#2 (permalink)
H after g, before i Resident. Joined in Jul 2004 Lives in N,BC,CA 8,087 posts Gave thanks: 48 Thanked 131 times	You're probably uploading a rather large SQL dump. You can either use php.ini to increase the timeout limit (may not work... CPanel uses a different PHP config if I recall) or upload the file to your server and use SSH to import (ideal) or upload the file and have support import the file or use a script to break up the imports and do it in chunks.

March 3rd, 2008, 6:22 PM	#4 (permalink)
boxcar Registered User Fresh Surpasser Joined in Feb 2008 4 posts Gave thanks: 0 Thanked 0 times	What is a large dump? My files in 2.2.MB uncompressed.

March 3rd, 2008, 7:34 PM	#5 (permalink)
H after g, before i Resident. Joined in Jul 2004 Lives in N,BC,CA 8,087 posts Gave thanks: 48 Thanked 131 times	Hmm. That shouldn't be an issue. I think support might be the route to go though... even if just to find out why a 2.2MB file is exceeding the execution time.

March 3rd, 2008, 7:46 PM	#6 (permalink)
boxcar Registered User Fresh Surpasser Joined in Feb 2008 4 posts Gave thanks: 0 Thanked 0 times	Support did restore my database so it is working now. The offered the suggestion that such trouble is "usually due to a slow connection on upload". I tried uploading the file compressed (36k) and uncompressed (2.2MB) but it timed out in both cases. Methinks there is possibly something else going on but at least it is working now. Thanks for your replies.

Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)