Hi. I am useing MiriaDB and OC 9.1.6.2. We are redoing our backup stratergy and wish to backup the database using another servfer on the same local network. I have set bind-address in /etc/mysql/mariadb.conf.d/mysql.cnf but also need to grant access to the owncloud database to the remote server. Have done some googeling and know I need to run a grant comand and possibly setup a user. It would be good for someone to advise on what grant etc. comand is best and the comand line on the remote server. I think the later is somethingf like
$ mysql -h192.168.1.50 -uowncloud -ppassword owncloud > backup.sql.
to aid comunicasion lets call the owncloud database 'owncloude' , the ownCloud server 192.168.1.100 and the backup server 192.168.1.110.
Regards,
Ben