pdb-backup-restore-1-0-0

PDB-BACKUP-RESTORE Versão 1.0.0

O PDB-BACKUP-RESTORE não realiza o restore automático de nenhum backup, mas sim te orienta como fazer a restauração.

Para ver todas as opções de execução basta acessar o help do script.

Copy to Clipboard

A utilização do script é bem simples, basta executar o script pdb-backup-restore e seguir com as orientações

Copy to Clipboard

pdb-backup-restore
***************************************
* Instructions for restoring a backup *
***************************************

The PDB-BACKUP is not a backup tool, but a set of scripts that facilitates and controls the generation of full and incremental MySQL backups through mysqldump, Percona Xtrabackup, MariaDB mariabackup or MySQL Enterprise Backup.

The PDB-BACKUP-RESTORE will not do the restore of the backup, but will show you all the necessary steps to complete the restoration.
***************************************

The first thing to do is tell which backup you want to restore, and then the necessary commands are displayed for the backup to be restored successfully.
Select exactly the backup you want to restore, if the desired backup is an incremental, the instructions displayed will be to restore from backup to the selected incremental backup.

Do you wish to continue? [Y/N] y
+-----------+---------------------+-------------+----------+-------------------------------------------------------------------+-------------+----------------------------------------------------------------------------------------------------------------------------+------+
| id_backup | start               | type        | sequence | name                                                              | program     | path                                                                                                                       | size |
+-----------+---------------------+-------------+----------+-------------------------------------------------------------------+-------------+----------------------------------------------------------------------------------------------------------------------------+------+
|       131 | 2019-07-14 00:00:01 | full        |        1 | 0e51ddcf0073de7148e1ebf52b4324ce-full_1_2019-07-14_000701         | mysqlbackup | /backup/pdb-backup/mysqlbackup/completed/0e51ddcf0073de7148e1ebf52b4324ce-full_1_2019-07-14_000701.tar         | 6.8G |
|       132 | 2019-07-15 12:00:01 | incremental |        2 | 0e51ddcf0073de7148e1ebf52b4324ce-incremental_2_2019-07-15_120701  | mysqlbackup | /backup/pdb-backup/mysqlbackup/completed/0e51ddcf0073de7148e1ebf52b4324ce-incremental_2_2019-07-15_120701.tar  | 377M |
|       133 | 2019-07-15 20:00:01 | incremental |        3 | 0e51ddcf0073de7148e1ebf52b4324ce-incremental_3_2019-07-15_200701  | mysqlbackup | /backup/pdb-backup/mysqlbackup/completed/0e51ddcf0073de7148e1ebf52b4324ce-incremental_3_2019-07-15_200701.tar  | 113M |
|       134 | 2019-07-16 12:00:01 | incremental |        4 | 0e51ddcf0073de7148e1ebf52b4324ce-incremental_4_2019-07-16_120701  | mysqlbackup | /backup/pdb-backup/mysqlbackup/completed/0e51ddcf0073de7148e1ebf52b4324ce-incremental_4_2019-07-16_120701.tar  | 318M |
|       135 | 2019-07-16 20:00:01 | incremental |        5 | 0e51ddcf0073de7148e1ebf52b4324ce-incremental_5_2019-07-16_200701  | mysqlbackup | /backup/pdb-backup/mysqlbackup/completed/0e51ddcf0073de7148e1ebf52b4324ce-incremental_5_2019-07-16_200701.tar  | 72M  |
|       136 | 2019-07-17 12:00:01 | incremental |        6 | 0e51ddcf0073de7148e1ebf52b4324ce-incremental_6_2019-07-17_120701  | mysqlbackup | /backup/pdb-backup/mysqlbackup/completed/0e51ddcf0073de7148e1ebf52b4324ce-incremental_6_2019-07-17_120701.tar  | 288M |
|       137 | 2019-07-17 20:00:01 | incremental |        7 | 0e51ddcf0073de7148e1ebf52b4324ce-incremental_7_2019-07-17_200701  | mysqlbackup | /backup/pdb-backup/mysqlbackup/completed/0e51ddcf0073de7148e1ebf52b4324ce-incremental_7_2019-07-17_200701.tar  | 90M  |
|       138 | 2019-07-18 12:00:01 | incremental |        8 | 0e51ddcf0073de7148e1ebf52b4324ce-incremental_8_2019-07-18_120701  | mysqlbackup | /backup/pdb-backup/mysqlbackup/completed/0e51ddcf0073de7148e1ebf52b4324ce-incremental_8_2019-07-18_120701.tar  | 324M |
|       139 | 2019-07-18 20:00:01 | incremental |        9 | 0e51ddcf0073de7148e1ebf52b4324ce-incremental_9_2019-07-18_200701  | mysqlbackup | /backup/pdb-backup/mysqlbackup/completed/0e51ddcf0073de7148e1ebf52b4324ce-incremental_9_2019-07-18_200701.tar  | 121M |
|       140 | 2019-07-19 12:00:01 | incremental |       10 | 0e51ddcf0073de7148e1ebf52b4324ce-incremental_10_2019-07-19_120701 | mysqlbackup | /backup/pdb-backup/mysqlbackup/completed/0e51ddcf0073de7148e1ebf52b4324ce-incremental_10_2019-07-19_120701.tar | 292M |
|       141 | 2019-07-19 20:00:01 | incremental |       11 | 0e51ddcf0073de7148e1ebf52b4324ce-incremental_11_2019-07-19_200701 | mysqlbackup | /backup/pdb-backup/mysqlbackup/completed/0e51ddcf0073de7148e1ebf52b4324ce-incremental_11_2019-07-19_200701.tar | 109M |
|       142 | 2019-07-20 12:00:02 | incremental |       12 | 0e51ddcf0073de7148e1ebf52b4324ce-incremental_12_2019-07-20_120702 | mysqlbackup | /backup/pdb-backup/mysqlbackup/completed/0e51ddcf0073de7148e1ebf52b4324ce-incremental_12_2019-07-20_120702.tar | 237M |
|       143 | 2019-07-20 20:00:01 | incremental |       13 | 0e51ddcf0073de7148e1ebf52b4324ce-incremental_13_2019-07-20_200701 | mysqlbackup | /backup/pdb-backup/mysqlbackup/completed/0e51ddcf0073de7148e1ebf52b4324ce-incremental_13_2019-07-20_200701.tar | 24M  |
|       144 | 2019-07-21 00:00:01 | full        |        1 | 0720092170d920db1aa5dac3fd6c8e70-full_1_2019-07-21_000701         | mysqlbackup | /backup/pdb-backup/mysqlbackup/completed/0720092170d920db1aa5dac3fd6c8e70-full_1_2019-07-21_000701.tar         | 6.9G |
|       145 | 2019-07-22 12:00:01 | incremental |        2 | 0720092170d920db1aa5dac3fd6c8e70-incremental_2_2019-07-22_120701  | mysqlbackup | /backup/pdb-backup/mysqlbackup/completed/0720092170d920db1aa5dac3fd6c8e70-incremental_2_2019-07-22_120701.tar  | 362M |
|       146 | 2019-07-22 20:00:01 | incremental |        3 | 0720092170d920db1aa5dac3fd6c8e70-incremental_3_2019-07-22_200701  | mysqlbackup | /backup/pdb-backup/mysqlbackup/completed/0720092170d920db1aa5dac3fd6c8e70-incremental_3_2019-07-22_200701.tar  | 158M |
|       147 | 2019-07-23 12:00:02 | incremental |        4 | 0720092170d920db1aa5dac3fd6c8e70-incremental_4_2019-07-23_120701  | mysqlbackup | /backup/pdb-backup/mysqlbackup/completed/0720092170d920db1aa5dac3fd6c8e70-incremental_4_2019-07-23_120701.tar  | 286M |
|       148 | 2019-07-23 20:00:01 | incremental |        5 | 0720092170d920db1aa5dac3fd6c8e70-incremental_5_2019-07-23_200701  | mysqlbackup | /backup/pdb-backup/mysqlbackup/completed/0720092170d920db1aa5dac3fd6c8e70-incremental_5_2019-07-23_200701.tar  | 119M |
|       149 | 2019-07-24 12:00:01 | incremental |        6 | 0720092170d920db1aa5dac3fd6c8e70-incremental_6_2019-07-24_120701  | mysqlbackup | /backup/pdb-backup/mysqlbackup/completed/0720092170d920db1aa5dac3fd6c8e70-incremental_6_2019-07-24_120701.tar  | 274M |
|       150 | 2019-07-24 20:00:01 | incremental |        7 | 0720092170d920db1aa5dac3fd6c8e70-incremental_7_2019-07-24_200701  | mysqlbackup | /backup/pdb-backup/mysqlbackup/completed/0720092170d920db1aa5dac3fd6c8e70-incremental_7_2019-07-24_200701.tar  | 106M |
|       151 | 2019-07-25 12:00:01 | incremental |        8 | 0720092170d920db1aa5dac3fd6c8e70-incremental_8_2019-07-25_120701  | mysqlbackup | /backup/pdb-backup/mysqlbackup/completed/0720092170d920db1aa5dac3fd6c8e70-incremental_8_2019-07-25_120701.tar  | 303M |
|       152 | 2019-07-25 20:00:02 | incremental |        9 | 0720092170d920db1aa5dac3fd6c8e70-incremental_9_2019-07-25_200701  | mysqlbackup | /backup/pdb-backup/mysqlbackup/completed/0720092170d920db1aa5dac3fd6c8e70-incremental_9_2019-07-25_200701.tar  | 103M |
|       153 | 2019-07-26 12:00:01 | incremental |       10 | 0720092170d920db1aa5dac3fd6c8e70-incremental_10_2019-07-26_120701 | mysqlbackup | /backup/pdb-backup/mysqlbackup/completed/0720092170d920db1aa5dac3fd6c8e70-incremental_10_2019-07-26_120701.tar | 283M |
|       154 | 2019-07-26 20:00:01 | incremental |       11 | 0720092170d920db1aa5dac3fd6c8e70-incremental_11_2019-07-26_200701 | mysqlbackup | /backup/pdb-backup/mysqlbackup/completed/0720092170d920db1aa5dac3fd6c8e70-incremental_11_2019-07-26_200701.tar | 210M |
+-----------+---------------------+-------------+----------+-------------------------------------------------------------------+-------------+----------------------------------------------------------------------------------------------------------------------------+------+

Enter which backup_id to restore:

Importante: Ao selecionar o id do backup a ser restaurado, se o ID for de um backup full apenas as orientações para restaurar esse backup serão exibidas, mas caso seja de algum incremental, será exibida as orientações para restaurar o backup full e todos os incrementais até o backup selecionado.

Copy to Clipboard

Enter which backup_id to restore: 135

Files that are part of this backup:

full           |mysqlbackup    |tar       |/backup/pdb-backup/mysqlbackup/completed/0e51ddcf0073de7148e1ebf52b4324ce-full_1_2019-07-14_000701.tar
incremental    |mysqlbackup    |tar       |/backup/pdb-backup/mysqlbackup/completed/0e51ddcf0073de7148e1ebf52b4324ce-incremental_2_2019-07-15_120701.tar
incremental    |mysqlbackup    |tar       |/backup/pdb-backup/mysqlbackup/completed/0e51ddcf0073de7148e1ebf52b4324ce-incremental_3_2019-07-15_200701.tar
incremental    |mysqlbackup    |tar       |/backup/pdb-backup/mysqlbackup/completed/0e51ddcf0073de7148e1ebf52b4324ce-incremental_4_2019-07-16_120701.tar
incremental    |mysqlbackup    |tar       |/backup/pdb-backup/mysqlbackup/completed/0e51ddcf0073de7148e1ebf52b4324ce-incremental_5_2019-07-16_200701.tar

Unzipping Backup Files

tar -zxvf /backup/pdb-backup/mysqlbackup/completed/0e51ddcf0073de7148e1ebf52b4324ce-full_1_2019-07-14_000701.tar --directory /backup/pdb-backup/mysqlbackup/completed
tar -zxvf /backup/pdb-backup/mysqlbackup/completed/0e51ddcf0073de7148e1ebf52b4324ce-incremental_2_2019-07-15_120701.tar --directory /backup/pdb-backup/mysqlbackup/completed
tar -zxvf /backup/pdb-backup/mysqlbackup/completed/0e51ddcf0073de7148e1ebf52b4324ce-incremental_3_2019-07-15_200701.tar --directory /backup/pdb-backup/mysqlbackup/completed
tar -zxvf /backup/pdb-backup/mysqlbackup/completed/0e51ddcf0073de7148e1ebf52b4324ce-incremental_4_2019-07-16_120701.tar --directory /backup/pdb-backup/mysqlbackup/completed
tar -zxvf /backup/pdb-backup/mysqlbackup/completed/0e51ddcf0073de7148e1ebf52b4324ce-incremental_5_2019-07-16_200701.tar --directory /backup/pdb-backup/mysqlbackup/completed

The following commands are for applying the backup, and may vary depending on the backup configuration used, more information look at the official documentation.
If the backup was performed with XtraBackup, MariaBackuo or MySQLBackup(MEB) and used the --compress option (see /etc/pdbtools.cnf -> _pdbtools_mariabackup_compress = 1 | _pdbtools_xtrabackup_compress = 1 | _pdbtools_mysqlbackup_compress = 1), the first step is decompress, otherwise you can skip this step(e.g. maribackup --decompress --remove-original ...)

mysqlbackup --backup-dir=/backup/pdb-backup/mysqlbackup/completed/0e51ddcf0073de7148e1ebf52b4324ce-full_1_2019-07-14_000701 --uncompress apply-log

mysqlbackup --incremental-backup-dir=/backup/pdb-backup/mysqlbackup/completed/0e51ddcf0073de7148e1ebf52b4324ce-incremental_2_2019-07-15_120701 --backup-dir=/backup/pdb-backup/mysqlbackup/completed/0e51ddcf0073de7148e1ebf52b4324ce-full_1_2019-07-14_000701 --uncompress apply-incremental-backup

mysqlbackup --incremental-backup-dir=/backup/pdb-backup/mysqlbackup/completed/0e51ddcf0073de7148e1ebf52b4324ce-incremental_3_2019-07-15_200701 --backup-dir=/backup/pdb-backup/mysqlbackup/completed/0e51ddcf0073de7148e1ebf52b4324ce-full_1_2019-07-14_000701 --uncompress apply-incremental-backup

mysqlbackup --incremental-backup-dir=/backup/pdb-backup/mysqlbackup/completed/0e51ddcf0073de7148e1ebf52b4324ce-incremental_4_2019-07-16_120701 --backup-dir=/backup/pdb-backup/mysqlbackup/completed/0e51ddcf0073de7148e1ebf52b4324ce-full_1_2019-07-14_000701 --uncompress apply-incremental-backup

mysqlbackup --incremental-backup-dir=/backup/pdb-backup/mysqlbackup/completed/0e51ddcf0073de7148e1ebf52b4324ce-incremental_5_2019-07-16_200701 --backup-dir=/backup/pdb-backup/mysqlbackup/completed/0e51ddcf0073de7148e1ebf52b4324ce-full_1_2019-07-14_000701 --uncompress apply-incremental-backup

If the backup was performed with XtraBackup or MariaBackup:
At the end of the backup preparation process, simply move the files to their date and adjust the permissions.
 -> chown -R mysql: mysql /var/lib/mysql/
And start the MySQL service

If the backup was performed with MySQLBackup(MEB):
MEB controls copyback, so this is the first step.
The datadir must be empty
 -> mysqlbackup --defaults-file=/usr/local/mysql/my.cnf --backup-dir=/export/backups/full apply-log copy-back
Now adjust the permissions.
 -> chown -R mysql: mysql /var/lib/mysql/
And start the MySQL service

If you have any questions, bug report or suggestions, send an email to pdbtools@performancedb.com
Thank you for using the scripts developed by PerformanceDB. These scripts are developed and distributed free of charge, from DBA to DBA.
www.performancedb.com
pdbtools@performancedb.com