A WordPress website is created and MySQL is the database for it. When tried to import the database to an empty database via Linux Command Shell we encountered below errors:
ERROR 1146 (42S02): Table 'xx-xxx-xxx-xxx' doesn't exist
ERROR 1273 (HY000): Unknown collation: 'utf8mb4_unicode_ci'
ERROR 1115 (42000): Unknown character set: 'utf8mb4'
What could be the possible cause for these errors? Or should we try an alternative step to restore my WordPress website?
The source database version is mysqlnd 5.0.12 and the destination database is mySQL 5.1.66.