Hi Trent
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.
Yes indeed he should have, and while SQL dumps may exist that's not what he wrote. SQL dumps are not by definition good either, the appropriate command line options depend on things like which storage engine(s) are used and what character sets. We regularly encounter dumps that cannot be sanely loaded, primarily due to character set issues. People are exceedingly slack in this respect, and only "start caring" when there's a drama which is obviously rather late. 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/