GET 24/7 LIVE HELP NOW

Announcement

Announcement Module
Collapse
No announcement yet.

Export/Import Individual Tables?

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

  • Export/Import Individual Tables?

    Hello, I want to use Xtrabackup to do non blocking backups of our MySQL databases but also want to maintain the ability to restore by table rather than just entire database. As such I came upon a article which I thought was quite relevant,http://www.percona.com/doc/percona-x...ables_ibk.html. It seems to imply that after running "xtrabackup --backup [...]" the innobackupex export command should be run instead of preparing with xtrabackup. I've tried doing that but no *.exp files were made. Is there something I'm missing?

  • #2
    Nevermind, I figured out from http://www.mysqlperformanceblog.com/...a-full-backup/ that what I wanted to run was:
    innobackupex --ibbackup xtrabackup --no-timestamp --password=<password> --export /var/lib/mysql-backups/`date +"%Y-%m-%d"`/

    innobackupex --ibbackup xtrabackup --apply-log --password=<password> --export /var/lib/mysql-backups/`date +"%Y-%m-%d"`/

    Comment

    Working...
    X