mysql的物理备份和增量备份
物理备份:
mysql
SHOW VARIABLES LIKE'datadir';
use hellodb;
SHOW TABLE STATUS;
mysql
FLUSH LOGS WITH READ LOCK;
\q
lvcreate -L 50M -n mysnap -s /dev/myvg/mydata
mysql
UNLOCK TABLES;
\q
mount /dev/myvg/mysnap /mnt
cd /mnt
cd data/
ls
tar -jcf /root/mysql.tar.bz2 hellodb ibdata1 ib_logfile* mysql-bin*
ls
cd
umount /mnt
lvremove --force /dev/myvg/mysnap
service mysqld start
ls /mydata/data
rm -rf /mydata/data/*
cd /usr/local/mysql
chown -R mysql:mysql data/
scripts/ --datadir=/mydata/data --user=mysql
killall mysqld
service mysqld start
service mysqld stop
cd /mydata
cd data
ls
tar xf /root/mysql.tar.bz2 -C ./
ls
service mysqld start
mysql
SHOW DATABASES;
增量备份:
SHOW
相关新闻>>
- 发表评论
-
- 最新评论 更多>>