how to update my sql ip2Coutry

Regular Joined: Sep 10, 2007 Posts: 53

I followed all the necessary uploads for the new sentinel 2.5.14. I successfully install it, and my question is, is my IP2Country is already updated? or do I have to import all those 100+sql files?

registered · Posted: Sun Nov 11, 2007 6:52 am

IP2C is not automatically updated. Yes, you have to import all the data, but you can do this, I believe, from the NukeSentinel --> Import Data menu option and start with the first one in the list and it is supposed to cycle through them all, country by country.

Posted: Sun Nov 11, 2007 7:30 am

As what ive read in the instruction, that in NukeSentinel ---> Import Data is not allowed because the sql file contains drop commands.

omg...thats too many to import in PMA... Smile

..I haven't finish all the importings, but its ok to add those later?

Posted: Mon Nov 12, 2007 7:22 pm

unwired, to be honest, I am not sure what you are referring to. Bob provides Import Data as a function, so I have to assume that it works??? However, I will admit that I do not use that. I take the raw SQL file (the full versions), join them together into one big file and then use BigDump to upload them all. Takes about 10 minutes end-to-end.

Posted: Fri Nov 16, 2007 7:49 am

You do not need to use PHPmyadmin at all. Just upload the files that are in the /import directory to your /import directory on the server. Then from the NS admin screen run the import data function. It will cycle thru all the countries and update them all. The documentation IS a little confusing but you don't need the SQL files at all. (You could do what Montego suggested, but I'd recommend just using the built in import function).

I have recommended some changes in the readme files that come with the IP2country download to make the process clearer. Heck: I came to this site today to try to figure out how to ban Ukraine.

edit: and using the search feature I found my answer ... import data, import to blocked ranges ... then select Ukraine from the list. Good bye Ukrainian hackers.