Clean up binary log files-Mysql
by Mohan[ Edit ] 2012-09-20 08:29:38
<font color=#0000B3>
<h2> Clean up binary log files</h2>. For a default install they may be in
/usr/local/var/
or
/var/lib/mysql/
with names ending in -bin.000001,-bin.000002,.. The following
command may help find out where the logs are located.
mysql> show variables like '%home%';
+---------------------------+-----------------+
| Variable_name | Value |
+---------------------------+-----------------+
| bdb_home | /var/lib/mysql/ |
| innodb_data_home_dir | |
| innodb_log_group_home_dir | ./ |
+---------------------------+-----------------+
mysql> reset master;
reset master;
Query OK, 0 rows affected (0.02 sec)
</font>