mysql> show master logs;
+------------------+-----------+
| Log_name | File_size |
+------------------+-----------+
| mysql-bin.000001 | 0 |
| mysql-bin.000002 | 0 |
| mysql-bin.000003 | 0 |
| mysql-bin.000004 | 0 |
| mysql-bin.000005 | 0 |
| mysql-bin.000006 | 0 |
| mysql-bin.000007 | 0 |
| mysql-bin.000008 | 0 |
| mysql-bin.000009 | 0 |
| mysql-bin.000010 | 0 |
| mysql-bin.000011 | 0 |
| mysql-bin.000012 | 0 |
| mysql-bin.000013 | 0 |
| mysql-bin.000014 | 0 |
| mysql-bin.000015 | 0 |
| mysql-bin.000016 | 0 |
| mysql-bin.000017 | 0 |
| mysql-bin.000018 | 0 |
| mysql-bin.000019 | 0 |
| mysql-bin.000020 | 0 |
| mysql-bin.000021 | 0 |
| mysql-bin.000022 | 0 |
| mysql-bin.000023 | 0 |
| mysql-bin.000024 | 0 |
| mysql-bin.000025 | 0 |
| mysql-bin.000026 | 492 |
| mysql-bin.000027 | 125 |
| mysql-bin.000028 | 507 |
| mysql-bin.000029 | 494 |
| mysql-bin.000030 | 106 |
+------------------+-----------+
30 rows in set (0.01 sec)
在 my.cnf文件中我配置的
datadir = /usr/local/mysql/var
log-bin = /usr/local/mysql/var/mysql-bin.log
这些和数据文件生成的目录是一致的呀
我在 /usr/local/mysql/var/ 目录下 执行 的
mysqlbinlog mysql-bin.000030
报错说找不到 很奇怪啊