Cant import data from france into IP2C

New Member Joined: May 21, 2006 Posts: 16

Hi all.....I tried several times to import the data from france into IP2Country but it seems as though its quarying out. The countries file is the largest amonst them reaching over 800 megs its the only country I cant import is there anyway I can import that file to the database without it quarying out?

Posted: Fri Aug 25, 2006 7:21 am

Something is not right. The entire table, once loaded, is less than 5MB in size with around 75,000 rows of data. Are you sure about that size figure?

I will assume that this is an update to this table. You may want to try and use the update SQL file in phpMyAdmin rather than using the import feature. See if it works then.

Posted: Fri Aug 25, 2006 9:15 am

I thought that was a little odd myself but believe is or not the France file in the imports folder is 896 KB with the newest distrobution of sentinel 2.502.

Since the largest one besides that one is United States which is at 465 KB why would France be almost twice that size?

Posted: Fri Aug 25, 2006 9:21 am

OMG I just looked at the SQL import file of france its at a whopping 2.25 megs in size and with a 60 second quary time that they gave me for my phpMyAdmin there is no way that will import before the 60 seconds is up so I may have to do it in parts.

Posted: Fri Aug 25, 2006 9:30 am

Ok I added it in parts through the phpMyAdmin and everything seems to be ok now

Thanks for the advice montego

Posted: Sat Aug 26, 2006 1:49 am

Dont forget that the 'file' size would naturally be larger than the actual 'size' of the data hld in the database due to the fact that the file has more content in the way of code.

Posted: Sat Aug 26, 2006 7:15 am

Dark_Dragon, you are welcome. Glad it worked for you.