MySQL data management backup and recovery case analysis video tutorial

• Chapter1 curriculum structure
• 1-1 MySQL error log and general query log
• 1-2 MySQL slow query log
• 1-3 MySQL binary log
• 1-4 MySQL binary log application demonstration case
• 1-5 MySQL data backup and recovery overview
• 1-6 Installation and use of community version MySQL backup tool
• 1-7 MySQL backup based on LVM snapshot
• 1-8 Case demonstration based on LVM backup data
• 1-9 Introduction to the mylvmbackup tool
• 1-10 Third-party backup tool xtrabackup realizes complete backup and recovery
• 1-11 The third-party backup tool xtrabackup realizes incremental backup and recovery
• 1-12 Third-party backup tool innobackupex backup case
• 1-13 The backup tool mysqlbackup in the enterprise version of MySQL realizes complete backup and recovery
• 1-14 The backup tool mysqlbackup in the enterprise version of MySQL implements incremental backup and recovery
• 1-15 The backup tool mysqlbackup in the enterprise version of MySQL realizes single file backup and recovery
• 1-16 Single file backup production and recovery case
• 1-17 How to recover to the most recent valid data after data loss
• 1-18 Detailed explanation of Myisam storage engine and repair of damaged or missing .frm files
• 1-19 Use the myisamchk command to repair the data table
• 1-20 Achieving accidental deletion recovery of MySQL data without backup
• 1-21 Detailed explanation of InnoDB storage engine
• 1-22 Repairing damaged InnoDB tablespace files
• 1-23 Data recovery case