Three methods for mysql backup: bitsCN.com
I. purpose of backup
Disaster Recovery: recover and restore damaged dataDemand Change: data needs to be restored to a time before the change due to demand changesTest: test whether the new function is
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
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
The MariaDB database management system is a branch of MySQL. It is mainly maintained by the open-source community and licensed by GPL. One of the reasons for developing this branch is that Oracle has the potential risk of shutting down the source of
I. Purpose of backup
Disaster recovery: recover and restore damaged dataDemand change: data needs to be restored to a time before the change due to demand changesTest: test whether the new function is available
Ii. Backup considerations
How long
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
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
Project Practice 6-mysql enterprise-level log management, backup and recovery practices, mysql enterprise-level
Mysql implements enterprise-level log management, backup, and recovery
Environment background:With the development of business, the
Related reading:MySQL backup and restore specific implementation http://www.linuxidc.com/Linux/2012-12/76257.htmThree ways to summarize MySQL backup and recovery http://www.linuxidc.com/Linux/2012-12/75428.htmMySQL backup restore (view, stored
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.