"Cannot resolve table name" error when applying MySQL dump to RDS
Just found out that this was a bug that has been fixed in the next release, MySQL 5.7.11.

Extract from the changelog:


  InnoDB: Creating a table with a full-text index and a foreign key constraint failed when foreign_key_checks was disabled. (Bug #22094601, Bug #78955)


It took me time to figure out that the full-text index was the source of the problem, I had to trim down my dump file line by line until the dump could be successfully imported.



Unfortunately RDS does not support MySQL 5.7.11 yet, so I had to work around this issue. Here is what I did:


created the dump file with mysqldump as usual
opened the dump file and commented out all FULLTEXT KEY lines
noted down these lines in notepad
imported the dump to the replica as usual
connected to the replica, and issued ALTER TABLE statements to add each full-text index I had in my notepad back to its table


This worked perfectly well and my tables are fully in sync now.