ip2country.csv file too big for step 3 of installation

Worker Joined: Dec 22, 2004 Posts: 135

I'm installing IP2C 2.1.3 new but the thing stalls when I get to step 3 because phpmyadmin says I can't do more than 50000 queries at once. Can I do this manually or do Ihave to do step 3 to finish the install? A lot of the file went into the DB, but "IP to Country" is still not a link in Sentinel Admin.

Posted: Wed Feb 23, 2005 10:41 am

With 2.2.0, which is in testing, you will be able to do the ip2country import i sections. Currently it's all or none Sad

Goto [ Only registered users can see links on this board! Get registered or login! ] and tour around to see the new import system.

Now I have also done a sql dump file, [ Only registered users can see links on this board! Get registered or login! ] , for the ip2c database. This file is 5 megabytes compressed to about 490 kb and can be saved to your local pc and then broken into smaller pieces to import thru phpMyAdmin.

Posted: Wed Feb 23, 2005 10:54 am

what i ended up doing was going into the csv file and delete the lines that had been successfully integrated into the tables. then i saved the new file (with only a few thousand lines now) and uploaded it over the original file. The i ran the IP2C installer again and it added the lines that were missing.