Created
November 7, 2011 15:15
-
-
Save stamm/1345255 to your computer and use it in GitHub Desktop.
mysql copy
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
#!/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 |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment