Two INNODB/mysql/Win questions from a new user:

[1] How long should I keep around copies of binarylog?
(They're used to recover in case of failure, yes?
(I'm also shutting down the databases and dumping 
them each night to a large text file as backup, too.)

[2] Can anyone offer advice (or links to articles, etc) on 
best practices for backing up INNODB/mydql systems, and doing 
preventative/routine maintenance?
 
Thanks from this newbie

--TO

dir
01/06/2004  06:06 PM         4,340,590 binarylog.015
01/07/2004  06:06 PM         3,704,180 binarylog.016
< many lines snipped>
03/02/2004  06:07 PM         6,124,181 binarylog.080
03/03/2004  09:10 PM         6,929,777 binarylog.081
03/04/2004  06:07 PM         5,813,520 binarylog.082
03/05/2004  01:15 PM         5,769,200 binarylog.083
03/05/2004  05:00 AM             2,324 binarylog.index


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

Reply via email to