IP2C Question for Patch 2.5.1

Posted: Thu Aug 10, 2006 4:04 pm

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.

Site Admin Joined: Jun 04, 2004 Posts: 6433

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?

Posted: Thu Aug 10, 2006 7:11 pm

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.

Posted: Thu Aug 10, 2006 7:25 pm

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

Posted: Thu Aug 10, 2006 7:30 pm

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

Posted: Thu Aug 10, 2006 7:38 pm

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?

Posted: Thu Aug 10, 2006 7:42 pm

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

Posted: Thu Aug 10, 2006 7:46 pm

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

Posted: Thu Aug 10, 2006 8:45 pm

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

Posted: Fri Aug 11, 2006 5:07 pm

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.

Posted: Sat Aug 12, 2006 3:10 pm

You can also use a script called BigDump.

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