Re: myhostname-bin.000nn @ /usr/local/mysql/var

2005-09-25 Thread Martijn van den Burg
Hi Miguel,

Those files are the binary logs that MySQL keeps of its doings. You can find 
more information here: http://dev.mysql.com/doc/mysql/en/binary-log.html.

Depending on the number of tables and the number of data-altering statements, 
these logs may become very big very quickly.


Kind regards,

--
/Martijn

On Sunday 25 September 2005 02:56, Miguel Cardenas wrote:
 Hello list

 I wanted to know how much space was using the database am working on, but
 found some big files I don't know what they do... these files are located
 in

/usr/local/mysql/var

 and are named 'myhostname-bin.000nn' (nn is 1 to 29 at this moment)... I
 don't know that are those files, so I did a 'less' on them and it appears
 to be binary data with mixed full insert commands for part of my existing
 database.

 My question is... why are those files there? are they really needed or can
 be removed? they are really big and contain old insert commands that will
 not be used never more... can I simple delete all of them?

 Thanks for any information!!!

-- 
/Martijn

-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]



myhostname-bin.000nn @ /usr/local/mysql/var

2005-09-24 Thread Miguel Cardenas
Hello list

I wanted to know how much space was using the database am working on, but 
found some big files I don't know what they do... these files are located in

   /usr/local/mysql/var

and are named 'myhostname-bin.000nn' (nn is 1 to 29 at this moment)... I don't 
know that are those files, so I did a 'less' on them and it appears to be 
binary data with mixed full insert commands for part of my existing database.

My question is... why are those files there? are they really needed or can be 
removed? they are really big and contain old insert commands that will not be 
used never more... can I simple delete all of them?

Thanks for any information!!!


-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]