If you have a text file and if you want to Insert data to your Database Table, You can do it with these instructions and screen shots.

1. You should run some sql queries to do it on your server
   In my case :
         server (local) is ==> localhost
         my table is ==> ipbank
         and my text file is ==> ipdata.txt

2. Goto your MYSQL command prompt, I am using phpMyAdmin




3. Then Insert the queries like this

LOAD DATA LOCAL INFILE '/opt/lampp/htdocs/site/ipdata.txt' INTO TABLE ipbank
FIELD...
Continue reading ...