Announcement

Announcement Module
Collapse
No announcement yet.

xtrabackup restore specific database from a full backup

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

  • xtrabackup restore specific database from a full backup

    Hi all,
    1) I whould like to restore a specipic database from a full backup
    2) And also to be able to resore it to a certain point in time
    meaning after restoring the database from last night , i wouldlike to rollforword the database with binary-logs

  • #2
    For
    1) http://www.mysqlperformanceblog.com/...a-full-backup/ & http://www.percona.com/doc/percona-x...porting-tables
    2) http://www.percona.com/doc/percona-x...overy_ibk.html

    Let us know, if you have any followup questions on that.

    Comment


    • #3
      Hi mirfan,

      I cannot find anything from your links that can help me restore a single database from an all-database backup. Two articles you referred only show how to restore a table. I really want to give xtradbbackup a try but the restoration part is a lot more complicated and hard to use than mysqldump.

      Comment


      • #4
        From percona xtrabackup tool if you need to recover one database from all databases backup. You can script it by automating the process for quick restore

        Comment

        Working...
        X