Search code examples
mysqldatabase-backupspercona

how to set name of backup directory generated by Percona xtrabackup?


I have installed percona-xtrabackup-24.2.4.4 to take full backups of MySql db. i run following command to take backup

innobackupex --user=user_name --password=pass dir_path

it created a directory with timestamp( e.g. 2016-09-26_12-36) of mySql db successfully, which contains complete DB backup.

The problem is, i want to specify the output directory name, which is by default created with timestamp.

Any ideas? i have read all the options percona mentioned but found nothing.


Solution

  • If I understood clearly I would suggest that you need smth like

    innobackupex --user=yourDBuser --password=MaGiCdB1 --no-timestamp /path/to/backupdir
    

    where

    --no-timestamp key tells not to create a time stamped directory to store the backup

    /path/to/backupdir - path to your backup file

    You can find information about --no-timestamp option here

    https://www.percona.com/doc/percona-xtrabackup/2.2/innobackupex/creating_a_backup_ibk.html