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 -> NukeSentinel™ v2.5.x
Author Message
Gremmie
Former Moderator in Good Standing


Joined: Apr 06, 2006
Posts: 2415
Location: Iowa, USA

PostPosted: Thu Aug 10, 2006 4:04 pm Reply with quote

Hi,

I did the following to update the IP2C stuff in the 2.5.1 patch. First, I concatenated all the .sql files together:

cat *.sql > all.txt

Then used my favorite editor to search and replace all the table names to match my $prefix.

Then renamed all.txt to all.sql and gzipped it.

Then used phpmyadmin SQL tab to upload and execute all.sql.gz.

Not too surprisingly, my browser timed out during this operation. Sad

I glanced at my data, and noticed all the Vietnam stuff looked right (it was at the end of the all.sql file). But how do I know it all ran ok? I now have 74919 rows in my ip2country table. Does that match anyone else who upgraded to 2.5.1?

Thanks.
 
View user's profile Send private message
kguske
Site Admin


Joined: Jun 04, 2004
Posts: 6383

PostPosted: Thu Aug 10, 2006 7:06 pm Reply with quote

A couple of questions:

Why not use the installer to load it?

Why not install one SQL at a time?

Not sure if that's the right number of records - can someone else verify?

_________________
I google, therefore I exist...
Only registered users can see links on this board! Get registered or login!
 
View user's profile Send private message
Gremmie
PostPosted: Thu Aug 10, 2006 7:11 pm Reply with quote

There is no installer for the 2.5.1 patch.

Why not install one SQL at a time? Because like I said, I needed to change ALL of the tables to match my prefix. And I thought I would take a chance they would all load at once rather than do each file by hand in phpMyAdmin, which is both tedious and error prone.
 
gregexp
The Mouse Is Extension Of Arm


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

PostPosted: Thu Aug 10, 2006 7:25 pm Reply with quote

True, Can you open it up with an editor that has a count added to it?

_________________
For those who stand shall NEVER fall and those who fall shall RISE once more!! 
View user's profile Send private message Send e-mail Visit poster's website AIM Address Yahoo Messenger MSN Messenger ICQ Number
Gremmie
PostPosted: Thu Aug 10, 2006 7:30 pm Reply with quote

darklord wrote:
True, Can you open it up with an editor that has a count added to it?


The all.sql file? Well I'm not sure that is too helpful, cause it drops some (but not all) tables, then inserts new rows. So every line in the file does not correspond to a row as there are DELETE's present; also there are rows that are untouched from 2.5.0, if you see what I mean. Very Happy
 
kguske
PostPosted: Thu Aug 10, 2006 7:38 pm Reply with quote

Re: loading all at once...maybe you could combine, then break into 5 big chunks...

Are you having any problems? Are people able to register and log in?
 
Gremmie
PostPosted: Thu Aug 10, 2006 7:42 pm Reply with quote

Yeah, I should have probably broken the combined file up into chunks, live and learn.

There are no problems as of yet. Just wanted to make sure I had all the new data imported.

So no one else has a row count? You guys haven't installed the patch yet? Mr. Green
 
kguske
PostPosted: Thu Aug 10, 2006 7:46 pm Reply with quote

You know how it is...the cobbler's shoes and all... Smile
 
manunkind
Client


Joined: Apr 26, 2004
Posts: 368
Location: Albuquerque, NM

PostPosted: Thu Aug 10, 2006 8:45 pm Reply with quote

I have 75,369. I'm pretty sure mine is up to date.

_________________
Only registered users can see links on this board! Get registered or login! 
View user's profile Send private message Visit poster's website
Gremmie
PostPosted: Fri Aug 11, 2006 5:07 pm Reply with quote

Thanks. It must have crapped out on me at some point. I don't think I'll do anything unless I start hearing about users getting banned again. I don't plan on using IP2C at least for now. Just have it activated to work around the banning of my AOL users.

I appreciate the efforts of the Sentinel developers. Cheers.
 
montego
Site Admin


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

PostPosted: Sat Aug 12, 2006 3:10 pm Reply with quote

You can also use a script called Only registered users can see links on this board! Get registered or login!.

You may also be able to count the number of INSERT statements in some good text editors or even a *nix command like:

grep INSERT <filename>|wc -l

_________________
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
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 -> NukeSentinel™ v2.5.x

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 ©