I've been using XAMPP successfully for a long while, but now I'm working with a large database. The table has only 7 fields but about 3000 records, and (hopefully) more to come. The db was originally created in Excel, which I then converted to a text file to import into mySQL. And it works for 127 records, but that's it. I've tried inserting 1 more record just using phpMyAdmin and get this message:
#1062 - Duplicate entry '127' for key 1
The problem doesn't appear to be with the text file (only 109kb) or the way I import it, since I get the first 127 records with no problem at all. And as I mentioned, inserting a new record manually doesn't work either. So is this a limitation of XAMPP, PHP, MySQL, or am I missing something?
Any and all help greatly appreciated