Ronald Wiplinger wrote:
I have a database server, but I would like to make a backup of some databases every hour via rsync. How can I do that? I use MySQL and SuSE 9.x
For the rsync part, look at the documentation for ssh. You would typically append the contents of ~/xyz/.ssh/id_rsa.pub on the machine that will initiate the rsync connexion to ~/xyz/.ssh/authorized keys on the remote machine. This allows you to do as xyz $ ssh remote.machine and login without a password. rsync uses ssh and so some command like $ rsync -Cavuz -e ssh xyz@remote.machine:data/ /home/xyz/data will do the backup for you. This doesn't, however, get round the problem that a busy database server may change files during an rsync operation. You may be able to lock the whole database for the duration. -- JDL