Backup Ranger Admin Database

You must execute the below commands on the Ranger database host.

MySQL

  1. First create directory (mkdir -p /root/backups/ranger/db/admin)
    $ mysqldump -u [username] -p db_name > dump_fileName.sql   
    or specify destination as
    /some_dir/dump_fileName.sql 
  2. Select the Enter key.
  3. Type the database password at the password prompt.

Example

mysqldump -u rangeradmin -p ranger > /root/backups/ranger/db/admin/ranger.sql

POSTGRES

  1. Dump the contents of a database to a file by running the following command. Replace database name with the name of the database to be backed up:

    pg_dump -U username dbname > dbname.bak

    Example

    pg_dump -U rangeradmin ranger > /root/backups/ranger/db/admin/db/ranger.sql
  2. Type the database password at the password prompt.