宝塔误删mysql_宝塔数据库被删除了,如何恢复

# cat /etc/my.cnf

log_bin=mysql-bin

# mysql -uroot -p

Enter password:

mysql> show variables like'log_bin%';

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

| Variable_name | Value |

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

| log_bin | ON |

| log_bin_basename | /home/programs/mysql-5.6.26/data/mysql-bin |

| log_bin_index | /home/programs/mysql-5.6.26/data/mysql-bin.index |

| log_bin_trust_function_creators | OFF |

| log_bin_use_v1_row_events | OFF |

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

5 rows in set (0.00 sec)

# ll /home/programs/mysql-5.6.26/data/mysql-bin*

-rw-rw---- 1 mysql mysql 343629748 Oct 13 22:09 /home/programs/mysql-5.6.26/data/mysql-b


版权声明:本文为weixin_34637857原创文章,遵循CC 4.0 BY-SA版权协议,转载请附上原文出处链接和本声明。