Xtrabackup migrate an INNODB table, xtrabackupinnodb

Xtrabackup migrate an INNODB table, xtrabackupinnodb

Mysql database. I want to delete a table. The primary key of this table is used as the foreign key of multiple other tables, InnoDB, and cascade deletion is set.

This operation obviously violates the original intention of designing these table relationships.

Cascade is useful in that when you delete a record, if the primary key value is deleted, cascade the data of the sub-table.

This does not apply to your current situation: deleting a master table !!!

We recommend that you think about why you want to delete the table.

To ensure security, delete the Foreign keys and then the primary table. We recommend that you back up the primary table before deleting it (to avoid regret)

The result of backing up the mysql database with xtrabackup is only data, but there are still insert statements.

All the data backed up, including the insert