[Borgbackup] Backup MySQL in Borg

[Catscrash]

Thanks Tomasz and Jasper for the stdin info, that's good to know.

Is it also possible to use the pipe as part of another repository, so
that the pipe input appears as one file in a specific path and as part
of the rest of the backed up data, or would I definitely need to have a
separate repository for this?

Thanks a lot!


Am 12.12.18 um 08:42 schrieb Tomasz Melcer:
> On 12.12.2018 08:28, Catscrash wrote:
>>           o There must be enough space to store the complete dump
>>             uncompressed, this can be an issue with databases in the
>>             region of 600gb+, it's not possible to keep that much space
>>             on all the systems
>
> I'm not using borg to back up databases, so I can't recommend any of
> these options, but at least this point is manageable: you can pipe the
> output of `mysqldump` into borg without storing the temporary file
> anywhere by giving `-` as the path to store.
>
> mysqldump … | borg create /your/repository::mysqldump-backup -
>
>