Hi,
I used this command to backup MySQL database and I am looking for a way to backup locally an extra copy.
Please could you help me?
innobackupex --user=Backupmysql --password=***** --stream=xbstream --compress /var/backup/ --compress-threads=2 --parallel=2 --no-lock --tmpdir=/tmp | pv -q -L50m | ssh ****** “xbstream -x -C /var/backupdst”
Geoffrey
Hello Geoffrey -
Wow - this is similar to a question I just answered here:
http://www.perconaforum.com/index.php?t=msg&th=3238& start=0&
You could include a copy of the final backup over to another directory or even a copy to another host using the cp command in a bash script.
I hope this helps -
extra copy was to avoid a sequential rsync linux command but anyway.