innobackupex --databases option not working with percona-server 5.5 or mysql server 5.1

[xinity]

hi all,

i've tried to use innobackupex to backup single databases using the "--databases" option.

i've tried this on percona-server-5.5 and mysql server 5.1 , but it backups all databases instead of the one i've selected.

did i miss something ?

thanks for your tips,

Regards,

[Tim Chadwick]

Can you elaborate on the evidence that it has backed up more than the databases you listed in the --databases option?

More detail on the full call you are making using innobackupex would also help.  I seem to recall submitting a change request for the --databases option because to include the note regarding streaming backups.

http://www.percona.com/doc/percona-xtrabackup/2.1/innobackupex/partial_backups_innobackupex.html

"Note

Currently in Percona XtraBackup the –databases option has no effect for InnoDB files for both local and streaming backups, i.e. all InnoDB files are always backed up. Currently, only .frm and non-InnoDB tables are limited by that option."

Thanks,

~tim

--
You received this message because you are subscribed to the Google Groups "Percona Discussion" group.
To unsubscribe from this group and stop receiving emails from it, send an email to percona-discuss...@googlegroups.com.
To post to this group, send email to percona-d...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

[xinity]

hi,

thanks for your answer, then for what purpose is the option "--databases" for ?

any idea of use case ?

if i understand, then --databases works only for MYISAM and .frm files ?

Regards,

On Tuesday, May 27, 2014 7:27:14 PM UTC+2, DynData wrote:

Can you elaborate on the evidence that it has backed up more than the databases you listed in the --databases option?

More detail on the full call you are making using innobackupex would also help.  I seem to recall submitting a change request for the --databases option because to include the note regarding streaming backups.

http://www.percona.com/doc/percona-xtrabackup/2.1/innobackupex/partial_backups_innobackupex.html

"Note

Currently in Percona XtraBackup the –databases option has no effect for InnoDB files for both local and streaming backups, i.e. all InnoDB files are always backed up. Currently, only .frm and non-InnoDB tables are limited by that option."

Thanks,

~tim

On Tue, May 27, 2014 at 11:57 AM, xinity <rzar...@gmail.com> wrote:

hi all,

i've tried to use innobackupex to backup single databases using the "--databases" option.

i've tried this on percona-server-5.5 and mysql server 5.1 , but it backups all databases instead of the one i've selected.

did i miss something ?

thanks for your tips,

Regards,

--
You received this message because you are subscribed to the Google Groups "Percona Discussion" group.

To unsubscribe from this group and stop receiving emails from it, send an email to percona-discussion+unsub...@googlegroups.com.

[Tim Chadwick]

On Wed, May 28, 2014 at 5:15 AM, xinity <rzar...@gmail.com> wrote:

hi,

thanks for your answer, then for what purpose is the option "--databases" for ?

any idea of use case ?

if i understand, then --databases works only for MYISAM and .frm files ?

 

I do not think you are following.  For the case of streaming backups, only a full backup is possible and the --databases argument is ignored.

 

Regards,

On Tuesday, May 27, 2014 7:27:14 PM UTC+2, DynData wrote:

Can you elaborate on the evidence that it has backed up more than the databases you listed in the --databases option?

More detail on the full call you are making using innobackupex would also help.  I seem to recall submitting a change request for the --databases option because to include the note regarding streaming backups.

http://www.percona.com/doc/percona-xtrabackup/2.1/innobackupex/partial_backups_innobackupex.html

"Note

Currently in Percona XtraBackup the –databases option has no effect for InnoDB files for both local and streaming backups, i.e. all InnoDB files are always backed up. Currently, only .frm and non-InnoDB tables are limited by that option."

Thanks,

~tim

On Tue, May 27, 2014 at 11:57 AM, xinity <rzar...@gmail.com> wrote:

hi all,

i've tried to use innobackupex to backup single databases using the "--databases" option.

i've tried this on percona-server-5.5 and mysql server 5.1 , but it backups all databases instead of the one i've selected.

did i miss something ?

thanks for your tips,

Regards,

--
You received this message because you are subscribed to the Google Groups "Percona Discussion" group.
To unsubscribe from this group and stop receiving emails from it, send an email to percona-discussion+unsub...@googlegroups.com.

To post to this group, send email to percona-d...@googlegroups.com.

For more options, visit https://groups.google.com/d/optout.

--
You received this message because you are subscribed to the Google Groups "Percona Discussion" group.

To unsubscribe from this group and stop receiving emails from it, send an email to percona-discuss...@googlegroups.com.