# How to log streaming backup

**URL:** <https://forums.percona.com/t/how-to-log-streaming-backup/7429>\
**Category:** Percona XtraBackup\
**Created:** [February 17, 2020, 1:46pm UTC](https://forums.percona.com/t/how-to-log-streaming-backup/7429 "2020-02-17T13:46:45Z")\
**Posts on this page:** 5\
**Page:** 1

<div class="post-metadata">

**Author:** ![pythondev1](https://avatars.discourse-cdn.com/v4/letter/p/f17d59/32.png) [@pythondev1](https://forums.percona.com/u/pythondev1)\
**Post date:** [February 17, 2020, 1:46pm UTC](https://forums.percona.com/t/how-to-log-streaming-backup/7429/1 "2020-02-17T13:46:45Z")

</div>

I am changing my backups to streaming and tar’ing them up.

dest=“streaming\_current\_backup/”;  
dest2=“streaming\_current\_backup”  
xtrabackup --backup --stream=tar --target-dir=$dest \> “$dest2/backup.tar”

How do I log the messages to a file. I’ve tried adding `> log.txt` but that did not work.

---

<div class="post-metadata">

**Author:** ![vaibhav\_upadhyay40](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/vaibhav_upadhyay40/32/9_2.png) [@vaibhav\_upadhyay40](https://forums.percona.com/u/vaibhav_upadhyay40)\
**Post date:** [June 12, 2020, 12:29pm UTC](https://forums.percona.com/t/how-to-log-streaming-backup/7429/2 "2020-06-12T12:29:22Z")

</div>

Hi @pythondev1   
Try this,  
xtrabackup --backup --stream=tar --target-dir=$dest \> “$dest2/backup.tar”&nbsp;\>\> log.txt 2\>&1  
  
Hope this helps.

---

<div class="post-metadata">

**Author:** ![pythondev1](https://avatars.discourse-cdn.com/v4/letter/p/f17d59/32.png) [@pythondev1](https://forums.percona.com/u/pythondev1)\
**Post date:** [June 19, 2020, 8:36am UTC](https://forums.percona.com/t/how-to-log-streaming-backup/7429/3 "2020-06-19T08:36:41Z")

</div>

Thanks I tried something similar and it worked.

---

<div class="post-metadata">

**Author:** ![vaibhav\_upadhyay40](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/vaibhav_upadhyay40/32/9_2.png) [@vaibhav\_upadhyay40](https://forums.percona.com/u/vaibhav_upadhyay40)\
**Post date:** [June 19, 2020, 10:40am UTC](https://forums.percona.com/t/how-to-log-streaming-backup/7429/4 "2020-06-19T10:40:23Z")

</div>

Happy to know @pythondev1 you found the solution. May be you can share in your comment. It will be helpful for other  
users. :)&nbsp;

---

<div class="post-metadata">

**Author:** ![pythondev1](https://avatars.discourse-cdn.com/v4/letter/p/f17d59/32.png) [@pythondev1](https://forums.percona.com/u/pythondev1)\
**Post date:** [June 19, 2020, 1:38pm UTC](https://forums.percona.com/t/how-to-log-streaming-backup/7429/5 "2020-06-19T13:38:37Z")

</div>

Sure here is my script.&nbsp;

```auto
xtrabackup --defaults-file=/etc/alternatives/my.cnf --defaults-group=mysqld2 --socket=/var/run/mysqld/db2.sock --user=root --password=$pwd_value --backup --stream=tar --target-dir=$dest 2&gt; $log | gzip - | ssh mysqluser@backupserver "cat - &gt; /data/mysql/$dest_folder/ $backup_file" &gt; /dev/null 2&gt;&amp;1

```