Can’t log into duplicated site

I’m trying to duplicate a live site to a local development deployment. The MySQL database get created but not with all the tables; the most important of which is the wp_users. I’ve tracked down the biggest problem to be with table rows being populated with an invalid datetime value of “0000-00-00 00:00:00”. According to MySql 5.7 reference manual the supported range is “1000-01-01 00:00:00”. If I change the datetime value accordingly, the tables load properly. That’s the first of my import problems.

The 2nd issue is also an invalid wp_options row that has an invalid option_value field. I’ve traced this down to an image “alt=” tag with questionable value. I haven’t found what set this row yet, but still looking.