"Fossies" - the Fresh Open Source Software Archive

Member "usr/share/man/man1/mysql-zrm.1" (26 Aug 2013, 8155 Bytes) of package /linux/privat/MySQL-zrm-3.0-release.tar.gz:


As a special service "Fossies" has tried to format the requested text file into HTML format (style: standard) with prefixed line numbers. Alternatively you can here view or download the uninterpreted source code file.

    1 mysql-zrm(1)                                                      mysql-zrm(1)
    2 
    3 
    4 
    5 NNAAMMEE
    6        mmyyssqqll--zzrrmm - Backup and recovery utility for ZRM for MySQL
    7 
    8 SSYYNNOOPPSSIISS
    9        mmyyssqqll--zzrrmm ----aaccttiioonn [ bbaacckkuupp | rreessttoorree | sscchheedduullee--bbaacckkuupp | rreeppoorrtt | lliisstt
   10        | ppuurrggee | ppaarrssee--bbiinnllooggss | cchheecckk  |  vveerriiffyy--bbaacckkuupp  |  eexxttrraacctt--bbaacckkuupp  |
   11        aabboorrtt--bbaacckkuupp ]
   12 
   13 
   14 DDEESSCCRRIIPPTTIIOONN
   15        ZRM  for  MySQL  provides  automated  scheduling of live MySQL database
   16        backup. You only need to configure it once to reflect the MySQL deploy-
   17        ment,  then  schedule it to run unattended backups. Various options can
   18        help an administrator:
   19 
   20        * Verify the backups created.
   21 
   22        * Generate various types of reports about the backups created.
   23 
   24        * Specify compression and encryption as desired.
   25 
   26        * Report information about the backups via an email or RSS feed.
   27 
   28        * Access pre- and post- backup plugins to extend the suite further.
   29 
   30        * Control full and selective restore operations on the  database,  both
   31        locally and remotely.
   32 
   33        ZRM  for  MySQL’s primary command line utility is mmyyssqqll--zzrrmm, which pro-
   34        vides the core backup/restore functions for MySQL databases.
   35 
   36        Use the mmyyssqqll--zzrrmm..ccoonnff(5) configuration file to set mmyyssqqll--zzrrmm  options.
   37        Use the ----aaccttiioonn cchheecckk option to verify the configuration of mmyyssqqll--zzrrmm.
   38 
   39        Use mmyyssqqll--zzrrmm to create full or incremental backups of MySQL  databases
   40        and  perform  full,  incremental  and  selective  restores as well. The
   41        ----lliisstt option provides information about prior backups.
   42 
   43        To display help on individual action options, append the ----hheellpp  option
   44        to the appropriate command line. For example: mmyyssqqll--zzrrmm ----aaccttiioonn bbaacckkuupp
   45        ----hheellpp
   46 
   47 
   48 BBAACCKKUUPP SSEETTSS
   49        ZRM for MySQL organizes the backups into ’backup sets.’ Each backup set
   50        defines:
   51 
   52        * a list of database(s) or table(s) within a database to back up
   53 
   54        * backup options to use on this backup set
   55 
   56        * scheduling options to use on this backup set.
   57 
   58        Backup sets are identified by a unique name.
   59 
   60 
   61        Every  backup  run (each time mmyyssqqll--zzrrmm is executed) is associated with
   62        one backup set. Various parameters can be associated with  each  backup
   63        run.
   64 
   65        mmyyssqqll--zzrrmm     first     reads    the    global    configuration    file
   66        (//eettcc//mmyyssqqll--zzrrmm//mmyyssqqll--zzrrmm..ccoonnff). The global configuration file  can  be
   67        overridden   by   any   backup   set   configuration   file  stored  in
   68        //eettcc//mmyyssqqll--zzrrmm//_b_a_c_k_u_p _s_e_t _n_a_m_e/ directory. The mmyyssqqll--zzrrmm  command  line
   69        options  will  override  the  parameters specified in the configuration
   70        files.
   71 
   72 
   73 BBAACCKKUUPP MMEETTHHOODDSS
   74        mmyyssqqll--zzrrmm backups can be either full or incremental.  Full backups  can
   75        be  logical backups or raw backups.  Logical backups contain SQL state-
   76        ments to recreate the database.  Raw backups are actual copies  of  the
   77        database files.
   78 
   79        When  logical  backup is specified, the utility uses only mmyyssqqlldduummpp for
   80        backing up specified databases and tables.
   81 
   82        When raw backup is specified, the utility has  the  ability  to  decide
   83        which  backup  mechanism to use for a particular database. If there are
   84        no transactional storage engine based tables in the specified database,
   85        it  uses  mmyyssqqllhhoottccooppyy for backing up that database. Otherwise, it uses
   86        mmyyssqqlldduummpp for backing up the specified database.
   87 
   88        An index file is also created in the backup directory. The  index  con-
   89        tains  the  details of what was backed up, how much data was backed up,
   90        what parameters were used to backup the data, how much time it took  to
   91        backup etc.
   92 
   93 
   94 RREECCOOVVEERRYY
   95        When  restoring databases, only the aallll--ddaattaabbaasseess and ddaattaabbaasseess options
   96        are allowed.  In the case of clusters, only the aallll--ddaattaabbaasseess option is
   97        allowed.
   98 
   99        When the backup contains only specific tables from a database, you need
  100        to specify mmyyssqqll--zzrrmm action as restore and the database name to restore
  101        the backed up tables.  Tables not included in the backup but present in
  102        the database will be left untouched.
  103 
  104 
  105 AACCTTIIOONNSS
  106        Specify bbaacckkuupp to initiate a backup run.
  107 
  108        Use rreessttoorree to restore from a specified backup.
  109 
  110        Use sscchheedduullee--bbaacckkuupp to setup the schedule for the backup.
  111 
  112        specify rreeppoorrtt to generate reports on backup runs.
  113 
  114        Use cchheecckk to verify if a backup set configuration is correct.
  115 
  116        Use lliisstt to display the backup level, the name of  the  directory  con-
  117        taining  the  backup  and the index of the last backup of the specified
  118        backup set.
  119 
  120        Action ppaarrssee--bbiinnllooggss will display the parsed output of the binary logs.
  121        This  is  useful  to  find out the log positions and/or timestamp to be
  122        used for restore operations.
  123 
  124        Specify ppuurrggee to remove backups present in the directory  specified  by
  125        the destination option whose retention policy has been exceeded.
  126 
  127        Specify vveerriiffyy--bbaacckkuupp to verify a backup
  128 
  129        Use eexxttrraacctt--bbaacckkuupp to uncompress/decrypt a specified backup
  130 
  131        Specify aabboorrtt--bbaacckkuupp to abort the backup run for a given backup-set.
  132 
  133 
  134 OOPPTTIIOONNSS
  135        ----aaccttiioonn bbaacckkuupp | rreessttoorree | sscchheedduullee--bbaacckkuupp | rreeppoorrtt |
  136                   lliisstt | ppuurrggee | ppaarrssee--bbiinnllooggss | cchheecckk | vveerriiffyy--bbaacckkuupp |
  137                   eexxttrraacctt--bbaacckkuupp | aabboorrtt--bbaacckkuupp
  138 
  139               These mutually exclusive ----aaccttiioonn options choose the basic func-
  140               tionality of the utility. This form cannot be used in  the  con-
  141               figuration file.
  142 
  143 
  144 
  145 FFIILLEESS
  146        //vvaarr//lliibb//mmyyssqqll--zzrrmm
  147               Directory under which all backup data is stored.
  148 
  149 
  150        //eettcc//mmyyssqqll--zzrrmm//_b_a_c_k_u_p _s_e_t _n_a_m_e//mmyyssqqll--zzrrmm..ccoonnff
  151               Configuration file ZRM for MySQL.
  152 
  153 
  154 RREETTUURRNN VVAALLUUEESS
  155        On success, zero is returned. On error, non-zero value is returned.
  156 
  157 
  158 SSEEEE AALLSSOO
  159        mysql-zrm-backup(1),     mysql-zrm-manage-backup(1),     mysql-zrm-man-
  160        age-backup(1),        mysql-zrm-restore(1),         mysql-zrm-check(1),
  161        mysql-zrm-list(1),    mysql-zrm-parse-binlogs(1),   mysql-zrm-purge(1),
  162        mysql-zrm-extract-backup(1),                mysql-zrm-verify-backup(1),
  163        mysql-zrm-abort-backup(1),                      mysql-zrm-scheduler(1),
  164        mysql-zrm-reporter(1), mysql-zrm.conf(5), mysqldump(1), mysqlbinlog(1),
  165        mysql(1),  lvm(8),  Zmanda  Recovery  Manager  for MySQL (http://mysql-
  166        backup.zmanda.com/)
  167 
  168 
  169 AAUUTTHHOORR
  170        Zmanda Inc. (http://www.zmanda.com)
  171 
  172 
  173 
  174 Zmanda, Inc.                     ZRM for MySQL                    mysql-zrm(1)