Directory Classification of backups Physical Backup and logical backup Hot and cold backup Full Backup and Incremental backup More content Full backup and Recovery Import and export databases in SQL statement format Export data in SQL statement
We know that data is at the heart of an enterprise IT architecture, and in order to prevent data loss or some other special purpose for some accidental reasons, it is especially important to make backups of the data at the usual times.First, why to
I. OverviewThe previous article about MySQL installation and basic use of MySQL, this article is a follow-up supplement, mainly for MySQL or mariadb backup and restore, it is well known that the data is the most important, so usually to the
I. Purpose of the backup
Disaster recovery. Recovering corrupted data in the event of a disaster
Audit. What is the database at a certain point in time?
Test. Test if new features are available
Second, the classification
First, the purpose of the backup
Do disaster recovery: Restore and restore corrupted dataChange in demand: need to restore data to change before it changesTesting: Testing whether new features are available
Second, backup needs to consider the
In order to ensure data security, the data needs to be backed up regularly. There are a number of ways to backup, and the effect is different. Once there is an error in the data in the database, you need to use the backed-up data for restore
1 Overview1.1 IntroductionXtrabackup is a MySQL database backup tool provided by Percona, officially described, which is the world's only one by one open source tools that enable hot provisioning of InnoDB and XTRADB databases.PXB (Percona
This article is based on the Dbaplus community on the 104th issue of the online sharing.Original: http://dbaplus.cn/news-11-1267-1.htmlInstructor IntroductionFeng YuPoint-and-melt Network Advanced DBA
Oracle OCM, MySQL OCP;
Currently
Copy Address: Https://www.linuxyw.com/download/xtrabackup.pdf http://www.linuxyw.comemail:[email protected] Xtrabackup to MySQL database backup and restore this document, just a simple study of the next, for the database full and ready to
The essence of a backup is to save a copy of the dataset, but the original data is constantly changing, so the backup can only revert to the data before the data changes. What about the changes? So it's important to develop a good backup strategy.I.
The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion;
products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the
content of the page makes you feel confusing, please write us an email, we will handle the problem
within 5 days after receiving your email.
If you find any instances of plagiarism from the community, please send an email to:
info-contact@alibabacloud.com
and provide relevant evidence. A staff member will contact you within 5 working days.