Clean up binary log files-Mysql

by Mohan 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>
997
like
0
dislike
0
mail
flag

You must LOGIN to add comments