List:General Discussion« Previous MessageNext Message »
From:Sasha Pachev Date:July 30 1999 5:43pm
Subject:Re: what happens if the system crash ?
View as plain text  
sinisa@stripped wrote:
> 
> Mike writes:
>  > Hi All,
>  > Some one have probebly already askd it before...but here goes.
>  >
>  > If my OS crashes (and i mean TOTALLY, something like major disk fail) and i
>  > have backups of the DB files, Can i just copy them (with neccery provelige,
>  > to the MySQL library and to use them again, or i need to do a dump (like MS
>  > SQL) in order to be able to use them again.
>  >
>  > If there is a easy to read manual about this issue i will be more then glad
>  > to read it.
>  >
>  > Thanks,
>  >
>  > Mike
>  >
>  >
>  >
>  >
> 
> Hi!
> 
> If tables are OK, i.e. all update processes have finished, you can use
> them on the same OS they have been made.
> 
> This is not valid for myisam tables, which can be used on any system.
> 
> Sinisa
> 

And even if the tables are half-cooked (the updates have not finished) -
isamchk will fix it most of the time.

-- 
Sasha Pachev
http://www.sashanet.com/ (home)
http://www.direct1.com/ (work)
Thread
SV: SV: Help ! Delete !Martin Edelius30 Jul
  • what happens if the system crash ?Mike30 Jul
    • what happens if the system crash ?sinisa30 Jul
    • Subject Identifiers?Chris J. DiBona30 Jul
  • Re: what happens if the system crash ?Sasha Pachev30 Jul
Re: Subject Identifiers?Fred Lindberg31 Jul