li26598296 发表于 2018-10-9 12:54:32

Xtrabackup备份mysql数据库

MariaDB [(none)]> show databases;  
+--------------------+
  
| Database         |
  
+--------------------+
  
| information_schema |
  
| hellodb            |
  
| mysql            |
  
| performance_schema |
  
| test               |
  
+--------------------+
  
5 rows in set (0.00 sec)
  

  
MariaDB [(none)]> use hellodb;
  
Reading table information for completion of table and column names
  
You can turn off this feature to get a quicker startup with -A
  

  
Database changed
  
MariaDB > show table status\G*************************** 1. row ***************************
  
         Name: classes
  
         Engine: InnoDB
  
      Version: 10
  
   Row_format: Compact
  
         Rows: 8
  
Avg_row_length: 2048
  
    Data_length: 16384
  
Max_data_length: 0
  
   Index_length: 0
  
      Data_free: 9437184
  
Auto_increment: 9
  
    Create_time: 2016-07-05 08:16:44
  
    Update_time: NULL
  
   Check_time: NULL
  
      Collation: utf8_general_ci
  
       Checksum: NULL
  
Create_options:
  
      Comment:
  
*************************** 2. row ***************************
  
         Name: coc
  
         Engine: InnoDB
  
      Version: 10
  
   Row_format: Compact
  
         Rows: 14
  
Avg_row_length: 1170
  
    Data_length: 16384
  
Max_data_length: 0
  
   Index_length: 0
  
      Data_free: 9437184
  
Auto_increment: 15
  
    Create_time: 2016-07-05 08:16:44
  
    Update_time: NULL
  
   Check_time: NULL
  
      Collation: utf8_general_ci
  
       Checksum: NULL
  
Create_options:
  
      Comment:
  
*************************** 3. row ***************************
  
         Name: courses
  
         Engine: InnoDB
  
      Version: 10
  
   Row_format: Compact
  
         Rows: 7
  
Avg_row_length: 2340
  
    Data_length: 16384
  
Max_data_length: 0
  
   Index_length: 0
  
      Data_free: 9437184
  
Auto_increment: 8
  
    Create_time: 2016-07-05 08:16:44
  
    Update_time: NULL
  
   Check_time: NULL
  
      Collation: utf8_general_ci
  
       Checksum: NULL
  
Create_options:
  
      Comment:
  
*************************** 4. row ***************************
  
         Name: scores
  
         Engine: InnoDB
  
      Version: 10
  
   Row_format: Compact
  
         Rows: 15
  
Avg_row_length: 1092
  
    Data_length: 16384
  
Max_data_length: 0
  
   Index_length: 0
  
      Data_free: 9437184
  
Auto_increment: 16
  
    Create_time: 2016-07-05 08:16:44
  
    Update_time: NULL
  
   Check_time: NULL
  
      Collation: utf8_general_ci
  
       Checksum: NULL
  
Create_options:
  
      Comment:
  
*************************** 5. row ***************************
  
         Name: students
  
         Engine: InnoDB
  
      Version: 10
  
   Row_format: Compact
  
         Rows: 25
  
Avg_row_length: 655
  
    Data_length: 16384
  
Max_data_length: 0
  
   Index_length: 0
  
      Data_free: 9437184
  
Auto_increment: 26
  
    Create_time: 2016-07-05 08:16:44
  
    Update_time: NULL
  
   Check_time: NULL
  
      Collation: utf8_general_ci
  
       Checksum: NULL
  
Create_options:
  
      Comment:
  
*************************** 6. row ***************************
  
         Name: teachers
  
         Engine: InnoDB
  
      Version: 10
  
   Row_format: Compact
  
         Rows: 4
  
Avg_row_length: 4096
  
    Data_length: 16384
  
Max_data_length: 0
  
   Index_length: 0
  
      Data_free: 9437184
  
Auto_increment: 5
  
    Create_time: 2016-07-05 08:16:44
  
    Update_time: NULL
  
   Check_time: NULL
  
      Collation: utf8_general_ci
  
       Checksum: NULL
  
Create_options:
  
      Comment:
  
*************************** 7. row ***************************
  
         Name: toc
  
         Engine: InnoDB
  
      Version: 10
  
   Row_format: Compact
  
         Rows: 0
  
Avg_row_length: 0
  
    Data_length: 16384
  
Max_data_length: 0
  
   Index_length: 0
  
      Data_free: 9437184
  
Auto_increment: 1
  
    Create_time: 2016-07-05 08:16:44
  
    Update_time: NULL
  
   Check_time: NULL
  
      Collation: utf8_general_ci
  
       Checksum: NULL
  
Create_options:
  
      Comment:
  
7 rows in set (0.00 sec)#全部都是InnoDB的,可以做热备。


页: [1]
查看完整版本: Xtrabackup备份mysql数据库