Re: rows skipped on mysql_upgrade for out-of-range datetimes

[Rick James]

ALLOW_INVALID_DATES, NO_ZERO_DATE, NO_ZERO_IN_DATE, TRADITIONAL
http://dev.mysql.com/doc/refman/5.0/en/server-sql-mode.html

Perhaps do this before the load (but in the same session):
SET sql_mode = 'TRADITIONAL';