The idea is to have backups.
Backups of unchecked data are not useless.
Backups of truncated data files are.
People have lost data when the disk became full during isamchk, or the
index had been crashed because it reached filesystem size limits.
If you blow the data away with a failed [my]isamchk then backup the
truncated files, what are you going to do?
If no errors were reported, the backup was clean.
If isamchk reports errors, and they were truely fixed, this backup is
repairable, and the next one should be clean.
The only time it should be an issue is if the check reports an error,
and examination of your databases show that data has been lost.
If this is the case you have the option to restore the unchecked files,
and recheck with different options.
Koen Gogne wrote:
> 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
>>> koen.gogne@stripped>>>
>>>
>>>
>>> ---------------------------------------------------------------------
>>> 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 <mysql-thread77143@stripped>
>>> To unsubscribe, e-mail
>>> <mysql-unsubscribe-gerald_clark=suppliersystems.com@stripped>
>>> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php>>
>>
>> --
>> Gerald L. Clark
>> gerald_clark@stripped>>
>>
>>
--
Gerald L. Clark
gerald_clark@stripped

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.