I have a MySQL 5.7.x dump with about 12GB that I try to import into a newly installed MySQL 8.0.x local instance.
mysql -u username -p test < DB-210508.sql
The import starts but fails with the following message:
ERROR 1824 (HY000) at line 518: Failed to open the referenced table 'table-name'
I am wondering why there is a problem with foreign keys and if it is not more due to the fact that I am importing into 8.0.x
The MySQL 8.0.x instance is configured like this:
[mysqld] default_authentication_plugin= mysql_native_password innodb_buffer_pool_size = 8G innodb_buffer_pool_instances = 32 innodb_buffer_pool_chunk_size = 134217728 collation_server = utf8_unicode_ci character_set_server = utf8
What could be the reason for the failed import?