Steps:
A/ FULL BACKUP a DATABASE
A.1/ Backup Full Single Database
A.2/ Backup Schema of Single Database
B/ FULL RESTORE a DATABASE
B.1/ Create new empty Database <New DBName>
B.2/ Import Schema (A.2) to new Empty Database
B.3/ Discard Tablespace
B.4/ Copy all file of Backuped Database (A.1) to new Database
B.5/ chown -R mysql.mysql /opt/mariadb/data/<New DBName>
B.6/ Import Tablespace for all new Table
B.7/ DONE
P.S:
1/ Backup full a MariaDB/MySQL Database in Binary mode
2/ Backup full all MariaDB/MySQL Database in Binary mode
3/ Backup Incremental a or all database in Binary mode
4/ Restore full a or all database in Binary mode
For detail script, contact to me
No comments:
Post a Comment