Re: MySQL Help needed [Scanned]

Arjen Lentz wrote:

...

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 [...]

Unless he did the backups while the server was off, isn't it likely that his backups of /var/lib/mysql will be incoherent? AIUI he should have backed up a dump of the database.