Hot answers tagged import
Given the clarifications on your comment, I would recommend 2 options: Use LOAD DATA INFILE IGNORE to load the data directly from the filesystem. This will insert new domains and not touch the "old" ones, but it will not delete the ones that are removed. On the bright side, it will reduce IO a lot. Go for your approach: use LOAD DATA INFILE on a new table, ...
Only top voted, non community-wiki answers of a minimum length are eligible