Backup related files with Databases by ZRM for MySQL

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:

 mysql-zrm-backup
                  [–all-databases] | [–databases “dbname1 dbname2″…] |
                  [–database “name” [–tables tname1 tname2 …]]
                  [–exclude-pattern pattern]
                  [–routines | –no-routines]
                  [–mysql-binpath MySQL_command_dir]
                  [–mysql-binlog-path MySQL_binary_log_dir]
                  [–config-file-list=”config_file_pathname”]

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.:
/etc/my.cnf
/var/lib/archive_files/arc_20110101.dat
/var/lib/archive_files/arc_20110102.dat
/var/lib/archive_files/arc_20110103.dat

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;

Advertisements
This entry was posted in MySQL. Bookmark the permalink.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s