MySQL主被删除数据问题_记录一下：关于mysql数据误删除恢复的问题

mysql> show table status from test where name='user';+------+--------+---------+------------+------+----------------+-------------+-----------------+--------------+-----------+----------------+---------------------+---------------------+------------+-----------------+----------+----------------+---------+

| Name | Engine | Version | Row_format | Rows | Avg_row_length | Data_length | Max_data_length | Index_length | Data_free | Auto_increment | Create_time | Update_time | Check_time | Collation | Checksum | Create_options | Comment |

+------+--------+---------+------------+------+----------------+-------------+-----------------+--------------+-----------+----------------+---------------------+---------------------+------------+-----------------+----------+----------------+---------+

| user | MyISAM | 10 | Dynamic | 5 | 20 | 144 | 281474976710655 | 3072 | 44 | 8 | 2017-01-11 18:03:54 | 2017-11-29 20:03:11 | NULL | utf8_general_ci | NULL | | |

+------+--------+---------+------------+------+----------------+-------------+-----------------+--------------+-----------+----------------+---------------------+---------------------+------------+-----------------+----------+----------------+---------+

1 row in set (0.01sec)

mysql> mysql> show table status from test where name='tiger';+-------+--------+---------+------------+------+----------------+-------------+-----------------+--------------+-----------+----------------+---------------------+-------------+------------+-------------------+----------+----------------+---------+

| Name | Engine | Version | Row_format | Rows | Avg_row_length | Data_length | Max_data_length | Index_length | Data_free | Auto_increment | Create_time | Update_time | Check_time | Collation | Checksum | Create_options | Comment |

+-------+--------+---------+------------+------+----------------+-------------+-----------------+--------------+-----------+----------------+---------------------+-------------+------------+-------------------+----------+----------------+---------+

| tiger | InnoDB | 10 | Compact | 3 | 5461 | 16384 | 0 | 0 | 0 | 14 | 2017-01-09 16:45:03 | NULL | NULL | latin1_swedish_ci | NULL | | |

+-------+--------+---------+------------+------+----------------+-------------+-----------------+--------------+-----------+----------------+---------------------+-------------+------------+-------------------+----------+----------------+---------+

1 row in set (0.00sec)

mysql>