[Maia-users] database issues
Ryan Delany
ryan at rynogear.com
Thu Aug 30 13:47:19 PDT 2007
> I've modified the my.cnf to comment out the log-bin line.
>
> Once I restart mysql, can I delete the mysql-bin.00000x files, and
> potentially the mysql-bin.index files?
>
> Kurt
Kurt,
I would move them first and see if everything is ok, but bottom line is
that without binary logging, those files aren't used/necessary any more.
Here is the output of my /var/lib/mysql directory:
-rw-rw---- 1 mysql mysql 2097152000 Aug 30 13:39 ibdata1
-rw-rw---- 1 mysql mysql 1048576000 Aug 13 16:02 ibdata2
-rw-rw---- 1 mysql mysql 104857600 Aug 30 13:39 ib_logfile0
-rw-rw---- 1 mysql mysql 104857600 Aug 30 08:21 ib_logfile1
drwx------ 2 mysql mysql 4096 Jun 30 09:25 maia
-rw-rw---- 1 mysql mysql 45014 Aug 13 16:02 <servername>.err
drwx------ 2 mysql mysql 4096 Apr 26 2006 mysql
srwxrwxrwx 1 mysql mysql 0 Aug 13 16:02 mysql.sock
drwx------ 2 mysql mysql 4096 Mar 10 09:22 test
Regards,
Ryan
More information about the Maia-users
mailing list