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

innobackupex backup process?

klabacitaklabacita ContributorCurrent User Role Novice

Just wondering, I have been working with this beautiful piece of software, the doc is clear in how to do full backups for innodb tables.

I can follow the manual without issue, but my question is this one:

1; We create the backup.
2; Prepare the full backup.

Here, once u run the first step, u have to run the second one right away?

The answer will apply to differential && incremental to?


Centos 5.7 x86
v 1.6.3.


  • xaprbxaprb Mentor Inactive User Role Beginner
    You can delay the second (prepare) step, but it's not a good idea. It makes your backup slower to restore because you have to do more work when you need the backup. And if something is wrong with it (or if there is a bug in xtrabackup) you want to find that out NOW, not when you need the backup.
  • klabacitaklabacita Contributor Current User Role Novice
    Hi xaprb.

    Good, if is better to run the 2nd step but will be slower I prefer to do it, at night we are not using the DB is went I run my backups I can wait.

    Thanks xaprb.
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.