Some tables may fail to load during dump import, especially when you do some migration when customers are waiting to resume service and your hands are shaking :)

Easy way to locate this problem is dividing your big .sql file using this tool https://github.com/kedarvj/mysqldumpsplitter

sh mysqldumpsplitter.sh --source big_file.sql  --compression none --extract ALLTABLES