innobackupex --include should mandatory include mysql db

Bug #723110 reported by Valentine Gostev
8
This bug affects 1 person
Affects Status Importance Assigned to Milestone
Percona XtraBackup moved to https://jira.percona.com/projects/PXB
Triaged
Low
Unassigned
2.0
Won't Fix
Low
Unassigned
2.1
Triaged
Low
Unassigned
2.2
Triaged
Low
Unassigned
2.3
Triaged
Low
Unassigned

Bug Description

When we perform a partial backup using innobackupex with --include="REGEXP" option, innobackupex backups MyISAM and InnoDB tables according to regular expression passed in the option.

If we do not specify explicitely in regexp mysql db makes backup unusable for restore to clean mysql datadir.

My Suggestion is that mysql db should be backuped anyway regardless was it specified in regexp or not.

Tags: pd
Changed in percona-xtrabackup:
status: New → Confirmed
description: updated
tags: added: pd
Changed in percona-xtrabackup:
importance: Undecided → Medium
importance: Medium → High
Revision history for this message
Valentine Gostev (longbow) wrote :

Only one feedback received on the list - rather posiive than negative.

Changed in percona-xtrabackup:
assignee: nobody → Valentine Gostev (core-longbow)
assignee: Valentine Gostev (core-longbow) → Vadim Tkachenko (vadim-tk)
Revision history for this message
Stewart Smith (stewart) wrote :

what about situation where don't want auth etc but do want just content of user tables?

(I don't view this as high priority as it is doing exactly what you tell it to do... and am open for it to be NotABug too.)

Changed in percona-xtrabackup:
importance: High → Low
Revision history for this message
Stewart Smith (stewart) wrote :

Vadim, also taking you off assigned-to. Feel free to claim it if it does get on your radar.

Changed in percona-xtrabackup:
assignee: Vadim Tkachenko (vadim-tk) → nobody
status: Confirmed → Triaged
Revision history for this message
Alexey Kopytov (akopytov) wrote :

We should also backup 'performance_schema'. Once this is fixed, a number of test cases related to partial backups can be simplified (e.g. grep for 'performance_schema').

Revision history for this message
Shahriyar Rzayev (rzayev-sehriyar) wrote :

Percona now uses JIRA for bug reports so this bug report is migrated to: https://jira.percona.com/browse/PXB-75

To post a comment you must log in.
This report contains Public information  
Everyone can see this information.

Other bug subscribers

Remote bug watches

Bug watches keep track of this bug in other bug trackers.