Hello, I am populating a database table with approx 500MB of information (Domain & NameServer Related). Currently, I am taking this huge 500MB text file & issuing a mysql console LOAD DATA IN FILE to a mysql Table. I am trying to keep things as simple as possible, would there be a simple mysql command I can issue that would compare both files & list out any changes such as: New Domain In A List A Domain Was Deleted From A DB Table Name Server / IP change / differences I guess all I really need to do is seperate any changes between the two database tables. I'm hoping this can be done easily without needing to parse the tables line by line, although I am open to anything just about. Furthermore, I would like to see if someone can share some simple code to provide a fast way of searching the database table line by line. Thanks!