So one of my hypervm servers, got a lot of corrupt binaries in the operating system, CentOS.
My datacenter has plugged in an external hard drive so I can backup my files there so the DC can reformat the server.
I know that I will need to copy: /vz and /home and /etc
But.. the one important thing is the hypervm MySQL database! What do I have to backup? /var/lib/mysql ? any other directories?
And how would I restore that MySQL to the new server, when hypervm is installed and the server is formatted?
I will be installing hypervm on the server again when it's done formatting.
I know that hypervm has exploits, so I am going to stop hypervm once I get the server up and running back on its feet. And then switch to VZWave when the production version comes out.
So can anyone shed some light into this? All your help is appreciated!
Mysql is traditionally in /var/lib/mysql but it could have been changed so don't just go by the directory. Look in that directory first to make sure it's all there before automatically assuming it.
PlatinumServerManagement (also known as PSM)
The OLDEST and LARGEST and MOST TRUSTED server management provider in the USA, with 15+ employees and growing! Providing quality support for OVER 18 years! Currently supporting over 3,000+ servers monthly! www.PlatinumServerManagement.com Proud member of the NJ BBB & Chamber of Commerce & Authorized cPanel Partner.
A few more little tips. Make sure MySQL is not running when moving the raw data files. The MySQL usernames and passwords are stored in MySQL's own database (usually /var/lib/mysql/mysql/), so yes, all of that will be preserved. You should of course also make sure you are going to restore the files to the same version of MySQL.