I picked the wrong day to give up sniffing glue! Been building a new WordPress site and I was trying to migrate it to a new domain when something went very wrong. I had a backup before you ask, but when I tried to restore it, things went tits up Here are the results of the MySQL CLI alchemy: (edited to just show errors)
mysql> source /var/www/html/.../updraft/wp.db
ERROR 1366 (HY000): Incorrect string value: '\xF0\x9F\x8E\x89</...' for column 'option_value' at row 125
ERROR 1067 (42000): Invalid default value for 'user_registered'
ERROR 1146 (42S02): Table 'wp_xxxxxxxxx.wp_users' doesn't exist
ERROR 1067 (42000): Invalid default value for 'comment_date'
ERROR 1146 (42S02): Table 'wp_xxxxxxxxx.wp_comments' doesn't exist
ERROR 1067 (42000): Invalid default value for 'link_updated'
ERROR 1067 (42000): Invalid default value for 'post_date'
ERROR 1146 (42S02): Table 'wp_xxxxxxxxx.wp_posts' doesn't exist
It’s not as bad as it looks; there are two errors basically • Attempted insert of string with 4-byte value fails • Invalid default value. This turns out to be a date value of '0000-00-00 00:00:00'…