jonaofarc Posted August 25, 2008 Share Posted August 25, 2008 Large Mysql file (ip address to city) Iam having a hard time importing, bc the first line of code is copyright info , when I use bigdump or try to import it as a csv into mysql it cant because of the copyright note on line 1 however I cant delete it because the file is too big (100MB) is there a way to get mysql to skip a couple of first lines any suggestions? Link to comment https://forums.phpfreaks.com/topic/121317-large-mysql-file-ip-address-to-city-iam-having-a-hard-time-importing/ Share on other sites More sharing options...
fenway Posted August 26, 2008 Share Posted August 26, 2008 LOAD DATA takes an optional IGNORE N LINES option. Link to comment https://forums.phpfreaks.com/topic/121317-large-mysql-file-ip-address-to-city-iam-having-a-hard-time-importing/#findComment-625974 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.