【已解决】show binlogs; ERROR 1064 (42000):

action08

mysql>
mysql> show binlogs;
ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'binlogs' at line 1
mysql>

action08

有没有一个查询bin log的工具啊，

RogerZhuo

回复 2# action08


    show binary logs;

action08

mysql> show binary logs;
+-------------------+-----------+
| Log_name          | File_size |
+-------------------+-----------+
| mysqld-bin.000001 |      1441 |
| mysqld-bin.000002 |       883 |
+-------------------+-----------+
2 rows in set (0.00 sec)

mysql>


我是新手，我接下来要问，这两个log默认在什么位置，怎么查看？？

action08

mysql>
mysql> show binary logs;
ERROR 1381 (HY000): You are not using binary logging


mysql还有个小问题，如果没有开启logbin，直接拒访

RogerZhuo

回复 5# action08
这个看看MySQL中的mysqlbinlog命令

   

action08

看上去优雅多了，谢谢。。

rucypli

需要在my.cnf里加log-bin参数  重启才能打开binlog