Hi Chris
Just looking for guidance, I have had a server crash, HDD failure, luckily I have good backups through Backup Exec 2012. What I need to know is what files do I need to restore to a basic install of the same distro (CentOS 5.8) to get our MySQL databases running again with the same security permissions?
Install MySQL server+client (RPMs). Grab your /etc/my.cnf from the backup, and /var/lib/mysql and copy those over the fresh install. /var/lib/mysql and below should be owned by mysql:mysql. This is the *very short* version - reality can be much more complex depending on the many possible factors involved. Also make sure the newly installed MySQL server is at last the same version or higher - best to be just the same. Cheers, Arjen. -- Exec.Director @ Open Query (http://openquery.com) MySQL services Sane business strategy explorations at http://Upstarta.biz Personal blog at http://lentz.com.au/blog/