MySQL 5.7 Errors Importing Dates 0000-00-00

One of the gotchas for users upgrading to MySQL 5.7 from previous versions is that strict mode is on by default. Thus, if you have dates in a dump file formatted as zeroes (e.g. 0000-00-00), your import will fail because that format is not allowed in in strict mode....