Insert using an INSERT IGNORE. If there's conflict on a unique or primary key, it will reject it and keep going instead of failing. Use either a bind and execute for the batch, or issue in groups of say 100.
This date format is fine for GNU. Run it through a dateTime object and output with the ::format method, or use strtotime and date to convert it to the proper string.