Restore from Backup Scenario - transfer to new server

@RoldanLT and @Matt are two people I know who have done numerous Centmin Mod server moves so hopefully they have some input

But yes generally that will work. You might want to read Centmin Mod Configuration Files - CentminMod.com LEMP Nginx web stack for CentOS for finer details of what config files and directories you may want to backup too. i.e. /etc/my.cnf changes etc

 

FYI, I do have future plans for Centmin Mod transfer data script similar to WHM to WHM transfer feature

For now some tips that you may want to test (no guarantees it works 100% and no support essentially), so @RoldanLT @Matt @Matt Williams @pamamolf @dorobo and other folks may want to test this on test VPS/data first

Requirements

• Needs to use ssh key (private/public key) setup and connection from source and destination servers

All commands in SSH as root user

Setup variables for remote destination server ip address, port and your ssh private key name and backup directory on local source server

Code (Text):

remoteip=111.222.333.444
port=22
privatekey=private.key
backupdir=/home/backupsql
DUMPOPT='-Q -K --max_allowed_packet=256M --net_buffer_length=65536 --routines --events --triggers --hex-blob'
CLIENTOPT='--max_allowed_packet=256M --net_buffer_length=65536'
mkdir -p $backupdir

rsync relevant data which assumes on remote destination server, centmin mod is installed but no vhosts or mysql databases have been created. It also assumes /root/.my.cnf is setup for mysql root user password which is automatically done on initial Centmin Mod installs

file data with rsync options -avzin where n is for dry run so no data is actually transferred. If all the dry runs look good, remove n to become -avzi for the below commands

dry run with 'n'

Code (Text):

cd /home
rsync -avzin --progress --stats -e "ssh -p $port -i $HOME/.ssh/$privatekey" --exclude 'domains/*/log' --exclude 'domains/*/backup' /home/nginx/ root@$remoteip:/home/nginx
rsync -avzin --progress --stats -e "ssh -p $port -i $HOME/.ssh/$privatekey" /usr/local/nginx/conf/ root@$remoteip:/usr/local/nginx/conf
rsync -avzin --progress --stats -e "ssh -p $port -i $HOME/.ssh/$privatekey" /etc/centminmod/custom_config.inc root@$remoteip:/etc/centminmod/custom_config.inc
rsync -avzin --progress --stats -e "ssh -p $port -i $HOME/.ssh/$privatekey" /usr/local/etc/php-fpm.conf root@$remoteip:/usr/local/etc/php-fpm.conf
rsync -avzin --progress --stats -e "ssh -p $port -i $HOME/.ssh/$privatekey" /etc/my.cnf root@$remoteip:/etc/my.cnf
rsync -avzin --progress --stats -e "ssh -p $port -i $HOME/.ssh/$privatekey" /etc/csf/csf.conf root@$remoteip:/etc/csf/csf.conf
rsync -avzin --progress --stats -e "ssh -p $port -i $HOME/.ssh/$privatekey" /etc/init.d/memcached root@$remoteip:/etc/init.d/memcached

live run without 'n'

Code (Text):

cd /home
rsync -avzi --progress --stats -e "ssh -p $port -i $HOME/.ssh/$privatekey" --exclude 'domains/*/log' --exclude 'domains/*/backup' /home/nginx/ root@$remoteip:/home/nginx
rsync -avzi --progress --stats -e "ssh -p $port -i $HOME/.ssh/$privatekey" /usr/local/nginx/conf/ root@$remoteip:/usr/local/nginx/conf
rsync -avzi --progress --stats -e "ssh -p $port -i $HOME/.ssh/$privatekey" /etc/centminmod/custom_config.inc root@$remoteip:/etc/centminmod/custom_config.inc
rsync -avzi --progress --stats -e "ssh -p $port -i $HOME/.ssh/$privatekey" /usr/local/etc/php-fpm.conf root@$remoteip:/usr/local/etc/php-fpm.conf
rsync -avzi --progress --stats -e "ssh -p $port -i $HOME/.ssh/$privatekey" /etc/my.cnf root@$remoteip:/etc/my.cnf
rsync -avzi --progress --stats -e "ssh -p $port -i $HOME/.ssh/$privatekey" /etc/csf/csf.conf root@$remoteip:/etc/csf/csf.conf
rsync -avzi --progress --stats -e "ssh -p $port -i $HOME/.ssh/$privatekey" /etc/init.d/memcached root@$remoteip:/etc/init.d/memcached

To transfer individual database name setup DBNAME variable with mysql database name, remote login to create database name and then mysqldump + pipe to remote db server the data

Code (Text):

DBNAME='dbname'
ssh root@$remoteip -p $port -i ~/.ssh/$privatekey mysqladmin create $DBNAME
mysqldump $DUMPOPT $DBNAME | ssh root@$remoteip -p $port -i ~/.ssh/$privatekey mysql $CLIENTOPT $DBNAME

list of database names, same as above just space separated list of mysql database names

Code (Text):

DBNAME='dbname dbname2 dbname3'
for db in $DBNAME; do ssh root@$remoteip -p $port -i ~/.ssh/$privatekey mysqladmin create $db; mysqldump $DUMPOPT $db | ssh root@$remoteip -p $port -i ~/.ssh/$privatekey mysql $CLIENTOPT $db; done

Note, this won't transfer custom created mysql usernames and passwords created on old server. You can easily backup mysql grants for this

this command outputs the list of db user grant statements which need replaying on destination mysql server (import into mysql system database)

Code (Text):

mysql --batch --skip-column-names -e "SELECT user, host FROM user" mysql | while read user host; do if [[ "$user" != 'root' ]]; then mysql --batch --skip-column-names -e "SHOW GRANTS FOR '$user'@'$host'" | sed -e 's|$|;|'; fi; done

Code (Text):

mysql --batch --skip-column-names -e "SELECT user, host FROM user" mysql | while read user host; do if [[ "$user" != 'root' ]]; then mysql --batch --skip-column-names -e "SHOW GRANTS FOR '$user'@'$host'" | sed -e 's|$|;|'; fi; done

GRANT USAGE ON *.* TO 'dbuser1'@'localhost' IDENTIFIED BY PASSWORD '*196BDEDE2AE4F84CA44C47D54D78478C7E2BD7B7';
GRANT SELECT, INSERT, UPDATE, DELETE, CREATE, DROP, ALTER, CREATE TEMPORARY TABLES, LOCK TABLES, EXECUTE ON `dbname2`.* TO 'dbuser1'@'localhost';

If anyone has something to add or if I missed anything, let me know

 

$HOME is system environment variable for the user you're logged in with

for root user = /root

for any linux system user you create or use it will be /home/username

you can find the system variable via 2 commands

Code:

echo $HOME

or

Code:

env

 

source server and yup remotely connect to create new database name

 

missing forward slashes on source parent directories doh

Code:

cd /home
rsync -avzin --progress --stats -e "ssh -p $port -i $HOME/.ssh/$privatekey" --exclude 'nginx/domains/*/log' --exclude 'nginx/domains/*/backup' /home/nginx/ root@$remoteip:/home/nginx
rsync -avzin --progress --stats -e "ssh -p $port -i $HOME/.ssh/$privatekey" /usr/local/nginx/conf/ root@$remoteip:/usr/local/nginx/conf

 

it should get cleared anyway later on so doesn't matter really

 

try instead of

Code (Text):

--exclude 'nginx/domains/*/log' --exclude 'nginx/domains/*/backup'

use

Code (Text):

--exclude 'domains/*/log' --exclude 'domains/*/backup'

it's relative to /home/nginx/

 

Wrote up a more detailed guide for Centmin Mod site/data migrations at https://community.centminmod.com/threads/centmin-mod-site-data-migration-guide.10382/