On Tue, Aug 03, 2004 at 11:16:43AM -0600, Michael Gale wrote: > Hello, > > I am new to mysql and am in the middle of upgrading our mysql > server to the latest release. Upon viewing our currently data > directory I noticed a large amount of hostname-bin-### files. > > Some of hostname-bin-### have time stamps of January -- from the > documentation I have read I can uses these to restore mysql data. So > am I correct in thinking that I can safely backup any > hostname-bin-### files older then let's say a week to a backup > server and then delete them from the data directory ?
I'd use the PURGE MASTER LOGS command rather than simply removing the files. We provide a sample script for something like this in Chapter 7 of High Performance MySQL. It's available here: http://dev.mysql.com/books/hpmysql-excerpts/ch07.html Jeremy -- Jeremy D. Zawodny | Perl, Web, MySQL, Linux Magazine, Yahoo! <[EMAIL PROTECTED]> | http://jeremy.zawodny.com/ [book] High Performance MySQL -- http://highperformancemysql.com/ -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
