Database Restoration Solutions with Percona XtraBackup

System Configuration and Properties

Operating Environment

Terminal Operating System: OS X 10.10.4
Server Environment: CentOS 6.5
Local Database Environment: Server version: 5.6.21-log MySQL Community Server (GPL)
Production Database Environment: MySQL5.5

Tools Used

Terminal Tool: iTerm (Mac)
Data Compression and Extract Tool: rds_backup_extract (applicable to RDS only)
Database Restoration Tool: Percona XtraBackup 2.2 Release 2.2.12

Database Backup Procedure

1.Download the RDS official extract tool kit: rds_backup_extract.

delete from mysql.db where user<>'root' and char_length(user)>0;
delete from mysql.tables_priv where user<>'root' and char_length(user)>0;
flush privileges;

Follow Up

That’s it! You have successfully restored your Alibaba Cloud ApsaraDB for RDS database. To learn more about backups on ApsaraDB for RDS, visit the official user guide.

--

--

Get the Medium app

A button that says 'Download on the App Store', and if clicked it will lead you to the iOS App store
A button that says 'Get it on, Google Play', and if clicked it will lead you to the Google Play store
Alibaba Cloud

Alibaba Cloud

Follow me to keep abreast with the latest technology news, industry insights, and developer trends. Alibaba Cloud website:https://www.alibabacloud.com