Faircube Networks - Custom programming projects, internet consulting, web design, and various other multimedia and graphic design solutions.
 
Home arrow MySQL arrow Cleaning up binary log files.
Cleaning up binary log files.

Clean up binary log files.  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)

 

 
 
Home | Services | Portfolio | Support | Prices | About Us | Privacy | Terms | Website Resources | Legal
Copyright © 1999-2007 Faircube Networks Inc. All Rights Reserved.