This is not a good idea I think, because when the check would report errors my backup would be useless ! the idea is to have clean backups, so I want to check before I do any backup and if necessary (when the check reports errors) restore the dammaged tables first. any other idea's ? regards Koen > > If you back them up before you check them, and the check blows up, you > still have your backups. > > Koen Gogne wrote: > >> hi, >> >> I'm trying to automate the back up of my MySQL databases, >> and before I perform my backup I check my tables using >> myisamchk and isamchk. >> When myisamchk and isamchk report errors I would like to catch that >> and maybe perform a restore operation. >> >> hence my question: what could go wrong when running myisamchk and isamchk >> and what could I get as error / warning messages ? >> Can I find a list of all the possible error messages ? >> >> for know I check the output of both myisamchk and isamchk >> for lines containing "error" and "warning" but I would like to search for >> more precise >> errormessages. >> >> Who can help me out ?` >> >> kind regards >> Koen Gogne >> [EMAIL PROTECTED] >> >> >> >> --------------------------------------------------------------------- >> Before posting, please check: >> http://www.mysql.com/manual.php (the manual) >> http://lists.mysql.com/ (the list archive) >> >> To request this thread, e-mail <[EMAIL PROTECTED]> >> To unsubscribe, e-mail >> <[EMAIL PROTECTED]> >> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php > > > -- > Gerald L. Clark > [EMAIL PROTECTED] > > > --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
