Backing up Baikal via SSH

/ Sven Boesiger / Raspberry Pi

Just a one-liner for backing up Baikal remotely:
ssh -C {REMOTE_USER}@{REMOTE_ADRESS} 'mysqldump --user={MYSQL_USER} --password={MYSQL_PASSWORD} {BAIKAL_MYSQL_DATABASE} | bzip2 -c' > baikal-backup.sql.bz2

– Needless to say that you need to add the public key of your client to servers known_keys (see here).

LEAVE A COMMENT