I set up the replication. my.cnf is the same(master-slave). but when I say show slave, I see that I get an error.
Last_SQL_Error: Error executing row event: ‘Table ‘table.tablename’ doesn’t exist’
I’m backing up with xtrabackup. I can restore.
Why does it give this error?
This means your data is not consistent between your primary and your replica, thus something that was successfully executed on the primary, fails when it’s trying to execute on the replica.
If I understood correctly, you’ve restored recently from the XtraBackup? If so, could you share how you restored the data and how you configured the replication?
If you can rebuild your replica it may be better than trying to fix this; since this error basically means the data in between your primary and your replica is not consistent. Here’s a simple tutorial on how to achieve this using Percona XtraBackup, take a look and I hope this helps you.