Announcement

Announcement Module
Collapse
No announcement yet.

innobackupex/xtrabackup, Is it possible to restore a single database instead of all?

Page Title Module
Move Remove Collapse
X
Conversation Detail Module
Collapse
  • Filter
  • Time
  • Show
Clear All
new posts

  • innobackupex/xtrabackup, Is it possible to restore a single database instead of all?

    All,

    I'm trying to find out how to restore a single database backed up by innobackupex/xtrabackup. I've been looking for an answer on this for a while and have only come across this option.

    http://www.tekovic.com/mysql-hot-backup-with-xtrabackup-on-c entos

    Near the bottom of the page it explains that to do this you have to restore the backup to a alternate mysql server and dump the db then restore it on the origin server. Is this really the only method for restoring a single database?
Working...
X