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? Quote Link to comment 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. Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.