Zmanda Recovery Manager for MySQL (ZRM for MySQL) is a robust backup and recovery solution for MySQL server. It can also be used to backup files related to databases. In the backup command mysql-zrm-backup,
it has an option to specify a list of files to be backedup togetehr with the databses in the backup set:
[–all-databases] | [–databases “dbname1 dbname2″…] |
[–database “name” [–tables tname1 tname2 …]]
[–routines | –no-routines]
The –config-file-list=”config_file_pathname” is used to specify the file that contains the files on the database server to be backed up.
1) The “config_file_pathname” is the full path name on the ZRM Server, not on the ZRM client (i.e. the database server is being backed up), e.g. /etc/mysql-zrm/server1-backup/files_to_backup.txt
2) In the file, each line is a full path file name to be backed up on the database server, e.g.:
3) ZRM for MySQL preserves the permission and timestamp etc when backing up the files sepcified in the config file. So the id of the owner and the id of the group of the files must be identical on both ZRM clients and ZRM server.
e.g. if the owner (id=27) and group (id=27) of /etc/my.cnf on server1 is mysql, the user/group of mysql on the ZRM server must have the same id;
4) The account used to run ZRM must be able to access those files;