I have a several small databases for dynamic web contents using ISAM and InnoDB formats, on my current MySQL server it runs a daily procedure that:
1.shuts down MySQLd; 2.runs isamcheck; 3.back up data dir tree; 4.restarts MySQLd; 5.dumps all data (so I have 'double' backup: 3.-data files and 5.-dumps) that takes 5 or 10 minutes whilst the server is down, and, I am just thinking whether 2 & 3 are really needed ...? what do others use for MySQL backup ? is there anything like isamcheck for InnoDB ? is there any practical need to run isamcheck, anyone does it ? any thoughts, suggestions, etc appreciated. also, is InfoZIP's ZIP & UNZIP OK to use on Linux files ? or, should I use tar/gzip/bzip2 ? Voytek Eymont -- SLUG - Sydney Linux User's Group - http://slug.org.au/ More Info: http://lists.slug.org.au/listinfo/slug
