Remote database backup


#1

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


#2

You might get better answers in a mariadb/mysql forum - I see no real connection to owncloud in this topic.