Not the answer you need?
Register and ask your own question!

XtraBackup and deleted files

kayjaykayjay EntrantCurrent User Role Beginner
This may sound a strange question but does a backup/restore cycle remove deleted records from a innodb database in the same way as in mysqldump?

Many thanks

Comments

  • martin.arrietamartin.arrieta Member Inactive User Role Beginner
    No, xtrabackup will not remove those deleted rows from the ibd or ibdata* files because xtrabackup will copy and use those files instead re-create them.

    To do that, you have to use mysqldump or if you have "innodb_file_per_table" enabled, you can use an alter table to re-create the table. "ALTER TABLE tablename ENGINE = InnoDB;"

    To avid locking in the alter table, you can use "pt-online-schema-change"

    Martin Arrieta.
Sign In or Register to comment.

MySQL, InnoDB, MariaDB and MongoDB are trademarks of their respective owners.
Copyright ©2005 - 2020 Percona LLC. All rights reserved.