Ravens PHP Scripts: Forums
 

 

View next topic
View previous topic
Post new topic   Reply to topic    Ravens PHP Scripts And Web Hosting Forum Index -> Security - Other
Author Message
kwality
Client


Joined: Dec 12, 2003
Posts: 35

PostPosted: Tue Aug 03, 2004 2:47 pm Reply with quote

Hey guys. Its been a while.

Im trying to upload a .sql into a new database.

Now, it seems to be working fine, but it 'exceeds timelimit' and cancels out.

Is it possible to break it up into a few smaller files and do them each individually?

Or is there another way to upload this .sql file

Any help is greatly appreciated.
 
View user's profile Send private message
kwality
PostPosted: Tue Aug 03, 2004 3:20 pm Reply with quote

my MySQL is screwed up i think...

i've tried many diff files, nothings uploading...

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


i get that every time.
 
sixonetonoffun
Spouse Contemplates Divorce


Joined: Jan 02, 2003
Posts: 2496

PostPosted: Tue Aug 03, 2004 3:38 pm Reply with quote

Mines 300 secs too I use BigDump to read large sql files. Only registered users can see links on this board! Get registered or login!
Might take some trial and error to get things going but it does do the job.

_________________
[b][size=5]openSUSE 11.4-x86 | Linux 2.6.37.1-1.2desktop i686 | KDE: 4.6.41>=4.7 | XFCE 4.8 | AMD Athlon(tm) XP 3000+ | MSI K7N2 Delta-L | 3GB Black Diamond DDR
| GeForce 6200@433Mhz 512MB | Xorg 1.9.3 | NVIDIA 270.30[/size:2b8 
View user's profile Send private message
kwality
PostPosted: Tue Aug 03, 2004 3:50 pm Reply with quote

seems awful confusing, but ill give it a go, thanks man
 
Raven
Site Admin/Owner


Joined: Aug 27, 2002
Posts: 17086

PostPosted: Tue Aug 03, 2004 7:25 pm Reply with quote

Your alternative is to break the file up (chunk it) and copy and paste maybe 5000 lines at a time into phpMyAdmin. Just ensure that you copy a complete line as the last line.
 
View user's profile Send private message
Raven
PostPosted: Wed Oct 06, 2004 11:47 pm Reply with quote

I wanted to *bump* this thread as there have been so many new users who visit and might not have seen this. This is an excellent utility. Check it out!
 
gregexp
The Mouse Is Extension Of Arm


Joined: Feb 21, 2006
Posts: 1497
Location: In front of a screen....HELP! lol

PostPosted: Sat Mar 18, 2006 9:16 pm Reply with quote

i hope this helps ppl who may not know this
but if ur file is too big u can split it up
with a fresh copy of the sql file...ie nuke...u can find certain codes
what i personally sudjest u do is to go about the middle of the file
look for the CREATE TABLE table_name.
now take everything from that line down...include that line
cut it out and paste it in a notepad....save it as something
i personally save these files as something.sql the sql part it to easily find and identify it for me personally...it can be saved in any text format....after that..upload the first half(what u didnt remove)
then upload the second half....if that doesnt work...try breaking it down even further...some ppl preferr like what was said before...copy and paste to an sql query...personally not my thing...but what ever floats your boat Laughing Laughing
 
View user's profile Send private message Send e-mail Visit poster's website AIM Address Yahoo Messenger MSN Messenger ICQ Number
jaded
Theme Guru


Joined: Nov 01, 2003
Posts: 1006

PostPosted: Sun Mar 19, 2006 11:28 am Reply with quote

using bigdump is very simple and by far the best way to upload a large sql

_________________
Themes BB Skins Only registered users can see links on this board! Get registered or login!
Graphic Tees Only registered users can see links on this board! Get registered or login!
Paranormal Tees Only registered users can see links on this board! Get registered or login!
Ghost Stories & More Only registered users can see links on this board! Get registered or login! 
View user's profile Send private message Visit poster's website
gregexp
PostPosted: Sun Mar 19, 2006 11:30 am Reply with quote

i agree 100%...this was just for those that found using big dump either difficult or perhaps didnt know....just informative is the only reason i posted.
 
bugsTHoR
Involved
Involved


Joined: Apr 05, 2006
Posts: 261

PostPosted: Fri Aug 18, 2006 1:43 pm Reply with quote

Personaly i zip it (not rar) it goes down from 19mb
to 3 or 4 mb
it does`nt time out for me then Very Happy happy days

i have 8mb max upload limit or 300 time

at first i copied and pasted the bbpost_topic / bbpost_txt as one (as it was massive.
then all the members and their info and forum stuff as one big one too also doing sentinel on its own to from the brand new(raven install) as one big one also. so at most there would be 4 .SQl files to upload , therefore missing max upload limit set from your host (mine is 10)

_________________
Only registered users can see links on this board! Get registered or login! LUV RAVEN DISTROBUTION BEBE

Clanthemes.com are great (free advertisements for now until i get to 20,000 posts LoL) 
View user's profile Send private message Visit poster's website
Raven
PostPosted: Fri Aug 18, 2006 2:52 pm Reply with quote

tar/zip (tar.gz or .tgz) will reduce it even further.
 
slackervaara
Worker
Worker


Joined: Aug 26, 2007
Posts: 236

PostPosted: Mon Oct 29, 2007 8:30 am Reply with quote

I use MySQLDumper for backup and restore my 370 MB sql file, because phpMyAdmin passes maximal execution time. Works very well. Only registered users can see links on this board! Get registered or login!
 
View user's profile Send private message
Display posts from previous:       
Post new topic   Reply to topic    Ravens PHP Scripts And Web Hosting Forum Index -> Security - Other

View next topic
View previous topic
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum
You can attach files in this forum
You can download files in this forum


Powered by phpBB © 2001-2007 phpBB Group
All times are GMT - 6 Hours
 
Forums ©