Bug #74073 Add docs for streaming a backup-dir
Submitted: 25 Sep 2014 13:30 Modified: 6 Mar 2015 17:04
Reporter: Daniël van Eeden (OCA) Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Enterprise Backup Documentation Severity:S3 (Non-critical)
Version:3.11.0 OS:Any
Assigned to: Daniel So CPU Architecture:Any
Tags: Backup, stream

[25 Sep 2014 13:30] Daniël van Eeden
Description:
http://dev.mysql.com/doc/mysql-enterprise-backup/3.11/en/meb-backup-streaming.html

I have a backup-dir which I want to stream to another server. This is not documented, but is proably possible.

How to repeat:
Try to stream an existing backup-dir to another server

Suggested fix:
Probably something like this should work:
mysqlbackup --backup-image=- --backup-dir=/path/to/my/backup backup-dir-to-image | ssh user@host 'mysqlbackup --backup-dir=backup_tmp --datadir=/data --uncompress --backup-image=- copy-back-and-apply-log'
[4 Dec 2014 18:52] Sveta Smirnova
Thank you for the report.

Yes, this should work. Did you try this command? Or do you complain about this works?
[4 Dec 2014 18:58] Sveta Smirnova
Ah! Just read report's subject. Do you simply want this to be documented?

Verified as documentation request, although this is something what Linux administrators should be familiar with and we have similar entry for backup-to-image at http://dev.mysql.com/doc/mysql-enterprise-backup/3.8/en/meb-backup-streaming.html
[4 Dec 2014 18:58] Sveta Smirnova
3.11 link: http://dev.mysql.com/doc/mysql-enterprise-backup/3.11/en/meb-backup-streaming.html
[6 Mar 2015 17:04] Daniel So
The suggested command has been added to the MySQL Enterprise Backup 3.11 and 3.12 manuals (except for the '--uncompress' option, as compression is not supported by the backup-dir-to-image command). Thanks for the suggestion!