GET 24/7 LIVE HELP NOW

Announcement

Announcement Module
Collapse
No announcement yet.

Backup one database with xtrabackup

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

  • Backup one database with xtrabackup

    Hello ;

    On my cluster PXC, I have several databases. I want to backup only one of them. But the instruction I find out in the manual don't show how to do it .

    I juste find how to backup all the databases, or how to do an incremental backup. Does someone know some particular command?

    Thanks in advance.

  • #2
    Percona Xtrabackup do supports Partial Backups. i.e. backup particular database/tables.
    You need to use --include, --tables-file or --databases option to backup selected database/tables.

    e.g.

    $ mysql --skip-column-names -e "SELECT CONCAT(table_schema,'.',table_name) FROM information_schema.tables WHERE table_schema = 'mydb';" > tables.txt
    $ innobackupex --tables-file=tables.txt /path/to/backupdir/

    Comment


    • #3
      You can also use mysqldump command as like below mentioned for taken a single mysql database backup.

      mysqldump -uabc -pabc dbname > dbname.sql

      if you need single table then

      mysqldump -uabc -pabc dbname tablenae > table.sql

      Comment

      Working...
      X