Importing a MySQL Dump with Bad Dates

A problem that I run into fairly regularly when transferring older sites to my local environment is that, when importing the MySQL dump, I get an error like: ERROR 1292 – Incorrect date value: ‘0000-00-00’ It seems that, prior to version 5.7, MySQL used to allow invalid dates like 0000-00-00. However, this behavior changed in…