On Tue, Mar 30, 2004 at 05:45:06PM -0500, Schwartz, Evelyn wrote: > Does anyone have a list of the files that need to be backed up for a > cold backup of an innodb database: > > Obviously all the MyISAM files and the innodb database files. But what > about the log and archive log files?
Yes, the logs too--unless you're absolutely sure you got a clean shutdown with nothing needed in the logs. But to be safe, just back 'em up too. -- Jeremy D. Zawodny | Perl, Web, MySQL, Linux Magazine, Yahoo! <[EMAIL PROTECTED]> | http://jeremy.zawodny.com/ MySQL 4.0.15-Yahoo-SMP: up 221 days, processed 4,200,626,989 queries (219/sec. avg) -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]