For an easy install batch file, see
this post
Oh and if you turn echo on, it nicely outputs the import errors to the dos window. Mostly duplicate Key values, but it works just fine anyhow.
Code:
mysql -f eqtest <faction_list.txt
ERROR 1062 at line 1: Duplicate entry '1' for key 1
ERROR 1136 at line 7: Column count doesn't match value count at row 1
ERROR 1136 at line 9: Column count doesn't match value count at row 1
ERROR 1136 at line 10: Column count doesn't match value count at row 1
ERROR 1062 at line 26: Duplicate entry '124' for key 1
ERROR 1136 at line 51: Column count doesn't match value count at row 1
mysql -f eqtest <loot.txt
ERROR 1050 at line 5: Table 'lootdrop' already exists
ERROR 1062 at line 420: Duplicate entry '3471' for key 1
ERROR 1064 at line 476: You have an error in your SQL syntax near '' at line 1
ERROR 1050 at line 562: Table 'lootdrop_entries' already exists
ERROR 1062 at line 1234: Duplicate entry '63-1160' for key 1
ERROR 1062 at line 1302: Duplicate entry '69-1160' for key 1
ERROR 1062 at line 1368: Duplicate entry '75-1160' for key 1
ERROR 1062 at line 1435: Duplicate entry '81-1160' for key 1
ERROR 1062 at line 1541: Duplicate entry '313-5013' for key 1
ERROR 1062 at line 1542: Duplicate entry '313-5021' for key 1
ERROR 1062 at line 1543: Duplicate entry '313-5022' for key 1
ERROR 1062 at line 1654: Duplicate entry '326-5013' for key 1
ERROR 1062 at line 1655: Duplicate entry '326-5021' for key 1
ERROR 1062 at line 1656: Duplicate entry '326-5022' for key 1
ERROR 1062 at line 1685: Duplicate entry '328-5013' for key 1
ERROR 1062 at line 1686: Duplicate entry '328-5021' for key 1
ERROR 1062 at line 1687: Duplicate entry '328-5022' for key 1
ERROR 1062 at line 1779: Duplicate entry '340-5021' for key 1
ERROR 1062 at line 1780: Duplicate entry '340-5022' for key 1
ERROR 1062 at line 1847: Duplicate entry '349-12590' for key 1
ERROR 1062 at line 1882: Duplicate entry '354-5013' for key 1
ERROR 1062 at line 1883: Duplicate entry '354-5021' for key 1
ERROR 1062 at line 1884: Duplicate entry '354-5022' for key 1
ERROR 1062 at line 1902: Duplicate entry '360-5015' for key 1
ERROR 1062 at line 2026: Duplicate entry '396-10119' for key 1
ERROR 1062 at line 2137: Duplicate entry '431-11909' for key 1
ERROR 1062 at line 2139: Duplicate entry '431-14753' for key 1
ERROR 1062 at line 2140: Duplicate entry '431-9205' for key 1
ERROR 1062 at line 2240: Duplicate entry '444-11936' for key 1
ERROR 1062 at line 2241: Duplicate entry '444-12811' for key 1
ERROR 1062 at line 2242: Duplicate entry '444-11936' for key 1
ERROR 1062 at line 2719: Duplicate entry '3401-5014' for key 1
ERROR 1062 at line 2957: Duplicate entry '3542-3012' for key 1
ERROR 1062 at line 2973: Duplicate entry '3542-12187' for key 1
ERROR 1062 at line 3239: Duplicate entry '3892-13053' for key 1
ERROR 1062 at line 3471: Duplicate entry '4614-16535' for key 1
ERROR 1062 at line 3540: Duplicate entry '1001-10119' for key 1
ERROR 1062 at line 3588: Duplicate entry '1002-15045' for key 1
ERROR 1062 at line 3689: Duplicate entry '1002-15145' for key 1
ERROR 1062 at line 3790: Duplicate entry '1002-15245' for key 1
ERROR 1062 at line 3891: Duplicate entry '1002-15345' for key 1
ERROR 1062 at line 3992: Duplicate entry '1002-15445' for key 1
ERROR 1062 at line 4093: Duplicate entry '1002-15545' for key 1
ERROR 1062 at line 4194: Duplicate entry '1002-15645' for key 1
ERROR 1062 at line 4295: Duplicate entry '1002-15745' for key 1
ERROR 1062 at line 4396: Duplicate entry '1002-15845' for key 1
ERROR 1062 at line 4578: Duplicate entry '1002-19245' for key 1
ERROR 1062 at line 4679: Duplicate entry '1002-19345' for key 1
ERROR 1062 at line 4780: Duplicate entry '1002-19445' for key 1
ERROR 1050 at line 4947: Table 'loottable' already exists
ERROR 1062 at line 5317: Duplicate entry '3364' for key 1
ERROR 1062 at line 5335: Duplicate entry '3394' for key 1
ERROR 1050 at line 5498: Table 'loottable_entries' already exists
mysql -f eqtest <merchantlist.txt
ERROR 1062 at line 195: Duplicate entry '12-10' for key 1
ERROR 1062 at line 752: Duplicate entry '58-17' for key 1
ERROR 1062 at line 785: Duplicate entry '60-20' for key 1
ERROR 1062 at line 786: Duplicate entry '60-20' for key 1
ERROR 1062 at line 992: Duplicate entry '83-14' for key 1
ERROR 1062 at line 993: Duplicate entry '83-15' for key 1
ERROR 1062 at line 1439: Duplicate entry '123-7' for key 1
ERROR 1062 at line 1440: Duplicate entry '123-8' for key 1
ERROR 1062 at line 1441: Duplicate entry '123-9' for key 1
ERROR 1062 at line 1442: Duplicate entry '123-10' for key 1
ERROR 1062 at line 1443: Duplicate entry '123-11' for key 1
ERROR 1062 at line 1444: Duplicate entry '123-12' for key 1
ERROR 1062 at line 1445: Duplicate entry '123-13' for key 1
ERROR 1062 at line 1446: Duplicate entry '123-14' for key 1
ERROR 1062 at line 1447: Duplicate entry '123-15' for key 1
ERROR 1062 at line 1448: Duplicate entry '123-16' for key 1
ERROR 1062 at line 1449: Duplicate entry '123-17' for key 1
ERROR 1062 at line 1480: Duplicate entry '127-4' for key 1
ERROR 1062 at line 2140: Duplicate entry '205-21' for key 1
ERROR 1062 at line 3011: Duplicate entry '246-4' for key 1
ERROR 1062 at line 3036: Duplicate entry '246-29' for key 1
ERROR 1062 at line 3134: Duplicate entry '90-5' for key 1
mysql -f eqtest <npc_faction.txt
mysql -f eqtest <npc_types.txt
mysql -f eqtest <spawn2.txt
mysql -f eqtest <spawnentry.txt
mysql -f eqtest <spawngroup.txt
mysql -f eqtest <zone_points.txt
ERROR 1062 at line 2: Duplicate entry '1' for key 1
ERROR 1062 at line 3: Duplicate entry '2' for key 1
ERROR 1062 at line 4: Duplicate entry '3' for key 1
ERROR 1062 at line 5: Duplicate entry '4' for key 1
ERROR 1062 at line 18: Duplicate entry '17' for key 1
ERROR 1062 at line 19: Duplicate entry '18' for key 1
ERROR 1062 at line 20: Duplicate entry '19' for key 1