digitalocean backup

I. What is full backup, differential backup, and Incremental backup? Introduction to Backup Types and combined backup solutionsFull backupBacking up all selected folders does not depend on the file archive attribute to determine which files to back up.(During the

Content of this Chapter Consistent and inconsistent RMAN backups Online backups and backup mode Backup Sets Image copies Multiple copies of RMAN backups Control File and server parameter file autobackups Incremental backups Backup retention policies 1. consistent and inconsistent backup of consistent and inco

Tags: SSO http csdn BSP Log net sequential ext utilizationA differential backup is a backup of all the differential data that is above a fully-available base point for this period.A log backup is a backup of the transaction log for this period based on the previous fully prepared + log

Xtrabackup backup of large databases (full backup and Incremental Backup) Xtrabackup Xtrabackup is a free Database Hot Backup Software open source by percona. It can back up InnoDB databases and XtraDB storage engine databases in non-blocking ways (Table locks are also required for MyISAM

Tags: Database incremental backup1, MySQL full-scale backup, incremental backup. Turn on MySQL's logbin log feature. Add the following code to the/etc/my.cnf file:[Mysqld]Log-bin = "/home/mysql/logbin.log"Binlog-format = ROWLog-bin-index = "/home/mysql/logindex"binlog_cache_size=32mmax_binlog_cache_size=512mmax_binlog_size=512m restart MySQL . users and groups with path/home/mysql are changed to MySQL. 2.

Script The code is as follows Copy Code #!/bin/bash function Installvpn () {echo "Begin to install VPN services";#check Wether VPS Suppot PPP and TunYum Remove-y pptpd PPPIptables--flush postrouting--table

Percona xtrabackup backup MySQL (full backup and incremental backup)Xtrabackup IntroductionPercona Xtrabackup is an open source, free MySQL database hot backup software that can back up non-blocking databases for InnoDB and XTRADB storage engines (for MyISAMBackup also requires a table lock). Xtrabackup supports all Pe

Tags: index create UPS ONS path reference repo support OfoXtrabackup IntroductionPercona Xtrabackup is open source free MySQL database hot backup software, it can be InnoDB and XTRADB storage Engine database non-blocking backup (for MyISAM backup also need to add a table lock). Xtrabackup supports all Percona servers, MySQL, mariadb, and drizzle.Xtrabackup Advant

" command will be executed, such: Myisamchk-o phpbb2_users.MYI This action may take 2 ~ 3 times until no error message appears! After repair, after restarting the MySQL service, you can use the mysql client command to Query the database content and test whether it is normal. fortunately, the database works normally at this time. Of course, before you back up the data, it would be better to check whether the data is correct first. If necessary, you can schedule the detection before the