Scripts to copy castom db to remote server

db_copy.sh

#!/bin/bash
#set -x

/etc/init.d/mysql stop
cp -R /var/lib/mysql/$1 /home/backup/  #copy /home/backup/ reqursively 
cd /home/backup/
tar -zcvf $1.tar.gz $1 #archive this
scp $1.tar.gz <user>@<host>:/home/$1.tar.gz //like root@XXX.xxx.xxx.xxx

#dont forget to set unix-style line endings

db_include.sh

#!/bin/bash
#set -x

/etc/init.d/mysql stop
cd /home
tar -xvf $1.tar.gz -C /home/inputtables/
mv /var/lib/mysql/$1  /home/backup/
mv /home/inputtables/$1 /var/lib/mysql/
chown mysql:mysql -R /var/lib/mysql/$1
cd /var/lib/mysql/$1
chmod 660 -R *
/etc/init.d/mysql start