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
Dark_Dragon
New Member
New Member


Joined: May 21, 2006
Posts: 16

PostPosted: Fri Aug 25, 2006 5:54 am Reply with quote

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?
 
View user's profile Send private message
montego
Site Admin


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

PostPosted: Fri Aug 25, 2006 7:21 am Reply with quote

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.

_________________
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
Dark_Dragon
PostPosted: Fri Aug 25, 2006 9:15 am Reply with quote

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?
 
Dark_Dragon
PostPosted: Fri Aug 25, 2006 9:21 am Reply with quote

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.
 
Dark_Dragon
PostPosted: Fri Aug 25, 2006 9:30 am Reply with quote

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

Thanks for the advice montego
 
Guardian2003
Site Admin


Joined: Aug 28, 2003
Posts: 6792
Location: Ha Noi, Viet Nam

PostPosted: Sat Aug 26, 2006 1:49 am Reply with quote

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.
 
View user's profile Send private message Send e-mail
montego
PostPosted: Sat Aug 26, 2006 7:15 am Reply with quote

Dark_Dragon, you are welcome. Glad it worked for you.
 
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 ©