Hi John,

>
> I am evaluating mySQL as an alternative to SQL Server...Other guy wants to
> go SQL Server, I kinda like mySQL...

Everybody has a prefered horse in the stable.
Their opinion is very subjective.


> What steps can be taken for mySQL so that I can be guaranteed to be ;
> a) ideally corruption free

mysql innodb is really enterprise level stable

> b) 100% safe if corruption does occur

use a hardware raid

Make regular backups like every professional does.
>
> Can anyone recommend any transaction logging tools, hot backup tools. Should
> I be worried about mySQL's atomicity? Im still fairly new to databases...I
> come from msaccess background...
>
Don't worry. MS is building playstations, mysql is building databases

kind regards,

Toni

--
Posen fuer Anfaenger: http://www.w-klch.med.uni-muenchen.de/dischner