doalitic/mysqlbackups repository overview

mkdir /tmp/restore
cd /tmp/restore
gsutil cp gs://gcsbucket/yYYYYwWW-complete.tar.bz2 .
tar xvf yYYYYwWW-complete.tar.bz2

innobackupex --apply-log /tmp/restore/backups/binary/yYYYYwWW-complete/

cd /tmp/restore
gsutil cp gs://gcsbucket/yYYYYwWW-incremental-dD-HHMM.tar.bz2 .
tar xvf yYYYYwWW-incremental-dD-HHMM.tar.bz2

innobackupex --apply-log --redo-only /tmp/restore/backups/binary/yYYYYwWW-complete/

innobackupex --apply-log /tmp/restore/backups/binary/yYYYYwWW-complete/ --incremental-dir=/tmp/restore/backups/binary/yYYYYwWW-incremental-dD-HHMM/

innobackupex --apply-log /tmp/restore/backups/binary/yYYYYwWW-complete/

docker stop myapp-mariadb

mkdir /tmp/oldmysql
mv /var/lib/mysql/* /tmp/oldmysql/

innobackupex --copy-back /tmp/restore/backups/binary/yYYYYwWW-complete/

docker start myapp-mariadb