Ravens PHP Scripts: Forums
 

 

View next topic
View previous topic
This forum is locked: you cannot post, reply to, or edit topics.   This topic is locked: you cannot edit posts or make replies.    Ravens PHP Scripts And Web Hosting Forum Index -> Raven's RavenNuke(tm) v1.x Distro
Author Message
Lateron
Worker
Worker


Joined: May 10, 2003
Posts: 119
Location: Katoomba, NSW, Australia.

PostPosted: Tue Nov 29, 2005 8:45 pm Reply with quote

I downloaded the 76 distro today and have now run the BigDump loader in INSTALLATION three times. It doesn't load any tables past 74 ( nuke_nsnst_ip2country ).

Any hints please?
 
View user's profile Send private message Visit poster's website
montego
Site Admin


Joined: Aug 29, 2004
Posts: 9449
Location: Arizona

PostPosted: Tue Nov 29, 2005 9:39 pm Reply with quote

Lateron, are you getting any error messages from BigDump or is it looking like it completes everything. You should get a message at the end of it saying that it has completed through the end of the file. Also, when it is cycling through its "batches" of inserts, does it halt on the last one for a very long time?

_________________
Only registered users can see links on this board! Get registered or login!
Only registered users can see links on this board! Get registered or login! 
View user's profile Send private message Visit poster's website
Raven
Site Admin/Owner


Joined: Aug 27, 2002
Posts: 17077

PostPosted: Tue Nov 29, 2005 9:46 pm Reply with quote

Maybe I will separate them (again) as originally distributed. Make sure that your MySQL max_queries is set to 0 if you control that. If not, BigDump should be handling this.
 
View user's profile Send private message
montego
PostPosted: Tue Nov 29, 2005 9:52 pm Reply with quote

Raven wrote:
Maybe I will separate them (again) as originally distributed. Make sure that your MySQL max_queries is set to 0 if you control that. If not, BigDump should be handling this.


I hadn't taken the time to look. I wasn't sure if BigDump was breaking apart by table or by actual physical records. That could also make a difference... maybe. Depending on the error or behaviour, I thought it might point us in the right direction.
 
Raven
PostPosted: Tue Nov 29, 2005 9:55 pm Reply with quote

He breaks apart by records.
 
Lateron
PostPosted: Tue Nov 29, 2005 10:06 pm Reply with quote

It starts the 5001 part, does something for a few minutes then I get a browser done msg (firefox) and then that's it.
 
Raven
PostPosted: Tue Nov 29, 2005 10:09 pm Reply with quote

Did you check the max_queries value?
 
Lateron
PostPosted: Tue Nov 29, 2005 10:13 pm Reply with quote

I am using hosting, I don't have any control over that do I, Gaylen?

Ron ...
 
Lateron
PostPosted: Tue Nov 29, 2005 10:37 pm Reply with quote

I am also creating a second phpNuke site today using this distro, and the same thing just happened: only created the first 74 tables.
 
Raven
PostPosted: Tue Nov 29, 2005 10:43 pm Reply with quote

Bigdump is set to restart after every 5000 queries. Are you running Apache or IIS? And, what version of PHP?
 
Lateron
PostPosted: Tue Nov 29, 2005 10:46 pm Reply with quote

Apache version 1.3.34 (Unix)
MySQL version 4.1.13-standard
PHP version 4.4.1
 
Raven
PostPosted: Tue Nov 29, 2005 10:50 pm Reply with quote

MySQL version 4.1.13-standard - BINGO!

That's not compatible. That is still not production release.
 
Lateron
PostPosted: Tue Nov 29, 2005 10:51 pm Reply with quote

So does that mean I can't install this distro?
 
Raven
PostPosted: Tue Nov 29, 2005 10:54 pm Reply with quote

So, do this. Unpack the tar.gz file to your local PC. Using a good text editor, cut the INSERT statements for the IP2COUNTRY table and save them to a file of their own. Then, save the edited (smaller) unpacked sql file. Using phpMyAdmin, load that sql file into your database. Then, once your base nuke tables are loaded, use phpMyAdmin and load the INSERT statements at a rate of maybe 8000 at a time.
 
Lateron
PostPosted: Tue Nov 29, 2005 10:55 pm Reply with quote

Thanks, Raven.

Cheers,
Ron ....
 
Raven
PostPosted: Tue Nov 29, 2005 10:55 pm Reply with quote

I'll try to figure out what the issue is with 4.1. But, not right away.
 
Lateron
PostPosted: Wed Nov 30, 2005 1:09 pm Reply with quote

I read in the BigDump instructions that it works better with unpacked file as it has to unzip it at the start of each sequence (in this case 5000).

So I uploaded an unzipped version of the sql file and this time it got to the start of sequence 30001 before it stopped.

The size of the database after it stopped is 2mb so it seems it is still stopped by the MySQL size limit.

Anyway it's morning here and I'm off to work without having slept. I had forgotten how much fun phpNuke can be! Razz

PS As for loading the lines a few thousand at a time I stopped after 3 hours realising I was looking at a HUGE amount of time to do that for two databases.
 
Loki
Worker
Worker


Joined: Oct 05, 2003
Posts: 107
Location: Illinois

PostPosted: Sat Dec 03, 2005 6:38 pm Reply with quote

Try uploading these one at a time. I broke it down to seven 10000 line files.
Only registered users can see links on this board! Get registered or login!
 
View user's profile Send private message Visit poster's website
Raven
PostPosted: Sat Dec 03, 2005 7:18 pm Reply with quote

Thanks for that! I have slightly rearranged the files and issued the v1.05.00 PATCH files.

Get the PATCH files at Only registered users can see links on this board! Get registered or login!

Get the full package at Only registered users can see links on this board! Get registered or login!
 
Lateron
PostPosted: Sun Dec 04, 2005 1:36 am Reply with quote

Thank you Loki and Raven, that worked a treat.

I appreciate the work you put into breaking down the file.

Regards,
Ron ....
 
Display posts from previous:       
This forum is locked: you cannot post, reply to, or edit topics.   This topic is locked: you cannot edit posts or make replies.    Ravens PHP Scripts And Web Hosting Forum Index -> Raven's RavenNuke(tm) v1.x Distro

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 ©