5,576
edits
Changes
Jump to navigation
Jump to search
Line 56:
Line 56: + + + + + + + + + + +
→RESTORING
NOTE: Make sure you use < and not > in the above command because you are piping the file.sql to mysql and not the other way around
NOTE: Make sure you use < and not > in the above command because you are piping the file.sql to mysql and not the other way around
===ENCRYPTION===
If you wish to encrypt your backups using openssl (no is default)
config setprop automysqlbackup Encrypt yes
you need to set a password (default is 01234567899876543210)
config setprop automysqlbackup Dbencrypt_password "your-password"
To decrypt run (replace gz with bz2 if using bzip2):
openssl enc -aes-256-cbc -d -in encrypted_file_name(ex: *.enc.gz) -out outputfilename.gz -pass pass:your-password