These are binary update log files. They keep track of all updates to your database. They are often used when restoring from a backup and also are required for replication. You can doa "FLUSH LOGS" and then move away the old logs or delete them if that is what you want to do. Be sure to always leave the log that is currently in use. You can check out for more information: http://www.mysql.com/doc/L/o/Log_file_maintenance.html
Harrison On Sun, 26 May 2002, Batara Kesuma wrote: > I have some very big files in my /var/lib/mysql. > [root@nias mysql]# ls -l nias-bin* > -rw-rw---- 1 mysql mysql 1073741921 5月 8 04:33 nias-bin.001 > -rw-rw---- 1 mysql mysql 875448838 5月 9 18:31 nias-bin.002 > -rw-rw---- 1 mysql mysql 86 5月 9 19:36 nias-bin.003 > -rw-rw---- 1 mysql mysql 1073741901 5月 12 04:32 nias-bin.004 > -rw-rw---- 1 mysql mysql 1073741885 5月 14 04:35 nias-bin.005 > -rw-rw---- 1 mysql mysql 1073741878 5月 16 04:37 nias-bin.006 > -rw-rw---- 1 mysql mysql 1073741948 5月 18 04:39 nias-bin.007 > -rw-rw---- 1 mysql mysql 750078444 5月 20 03:25 nias-bin.008 > -rw-rw---- 1 mysql mysql 1073742339 5月 22 04:32 nias-bin.009 > -rw-rw---- 1 mysql mysql 1073742314 5月 24 04:32 nias-bin.010 > -rw-rw---- 1 mysql mysql 1073742497 5月 26 04:32 nias-bin.011 > -rw-rw---- 1 mysql mysql 453278435 5月 26 04:51 nias-bin.012 > -rw-rw---- 1 mysql mysql 180 5月 26 04:32 nias-bin.index > > What files are them? Is it ok to delete all of them? Since I am running > out of space. > > > --------------------------------------------------------------------- > Before posting, please check: > http://www.mysql.com/manual.php (the manual) > http://lists.mysql.com/ (the list archive) > > To request this thread, e-mail <[EMAIL PROTECTED]> > To unsubscribe, e-mail <[EMAIL PROTECTED]> > Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php > > > --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php