mysql copy

mysql.sh

#!/bin/sh

if [ ! -f "$1" ]; then
    echo "File $1 not exists"
    exit;
fi
mysqlPath="/var/lib/mysql.bak.`date +%Y%m%d_%H%M`"
sudo mkdir $mysqlPath

sudo service mysql stop

if [ -d /var/lib/mysql ]; then
    sudo mv /var/lib/mysql/* $mysqlPath
fi
#sudo mkdir /var/lib/mysql/
#sudo cp -R ~/share/backup/mysql/* /var/lib/mysql
pv "$1" | tar xzf - -C /tmp/

sudo mv /tmp/backup/mysql/* /var/lib/mysql

rm -rf /tmp/backup /tmp/backup-pos

sudo chown mysql.mysql -R /var/lib/mysql/
sudo /usr/bin/mysqld_safe --skip-grant-tables &

sleep 5
mysql -e 'slave stop;'
mysql -e 'reset slave;'

echo "UPDATE user SET password=PASSWORD('toor') WHERE user='root';" | mysql --user=root mysql -Bs

sudo pkill -9 mysqld_safe

sleep 2
sudo mysql_upgrade -u root -ptoor

sleep 10
sudo service mysql start