859
edits
Changes
From SME Server
Jump to navigationJump to search→DB command option
the possibility is given to you to save a local directory by automysqlbackup. I suppose that you can not use it for large folder but for a web site with its database it could be useful. not activated by default
the possibility is given to you to save a local directory by automysqlbackup. I suppose that you can not use it for large folder but for a web site with its database it could be useful. not activated by default
config setprop automysqlbackup Backup_local_files /path/to/folder
config setprop automysqlbackup Backup_local_files /path/to/folder
===Mysql53, Mysql55, Mysql57, MariaDB===
With SCL on SME you may be running other database versions.
You must make sure you have a backup user for the newer databases
Creating backup user for default mysql53 database
done
*** If you add mysql55/mysql57 you must add a backup user ***
You can use the password from config show automysqlbackup
e.g.:
mysql55 -e " GRANT EVENT,SELECT,LOCK TABLES ON *.* TO backupuser@'localhost' "
mysql55 -u root -e "SET PASSWORD FOR backupuser@localhost = PASSWORD( ' -from config show automysqlbackup DbPassword- ' ) "
We can now choose other databases to backup:
mysql53, mysql55, mysql57, mariadb
You can enable or disable as follows:
config setprop mysql55 enabled
signal-event automysqlbackup-update
===Encryption===
===Encryption===
