centos6.9安装mysql5.7及自动备份(含mongodb及自动备份)

rpm -ivh mysql-community-common-5.7.18-1.el6.x86_64.rpm

rpm -ivh mysql-community-libs-5.7.18-1.el6.x86_64.rpm

rpm -ivh mysql-community-client-5.7.18-1.el6.x86_64.rpm

rpm -ivh mysql-community-server-5.7.18-1.el6.x86_64.rpm

11. 定期自动备份

#!/bin/bash
db_user&＃61;"root"
db_passwd&＃61;"123456"
db_name&＃61;"test_db"
#进入备份目录将之前的移动到old目录
cd /home/backup/bakmysql
echo "you are in bakmysql directory now"
mv test_db* /home/backup/bakmysqlold
echo "Old databases are moved to bakmysqlold folder"
#备份目录
backup_dir&＃61;"/home/backup/bakmysql"
#时间格式
time&＃61;$(date &＃43;"%Y-%m-%d")
#mysql 备份的命令&＃xff0c;注意有空格和没有空格
mysqldump -u$db_user -p$db_passwd $db_name > "$backup_dir/$db_name"-"$time.sql"
echo "your database backup successfully completed"
#这里将7天之前的备份文件删掉
SevenDays&＃61;$(date -d -7day &＃43;"%Y-%m-%d")
if [ -f /home/backup/bakmysqlold/pashanhu-$SevenDays.sql ]
then
rm -rf /home/backup/bakmysqlold/pashanhu-$SevenDays.sql
echo "you have delete 7days ago bak sql file "
else
echo "7days ago bak sql file not exist "
echo "bash complete"
fi

然后通过下面命令将脚步加入系统的计划任务

touch /home/bakmysql.sh
vi /home/bakmysql.sh (上面的脚本)
chmod -x /home/bakmysql
 mkdir /home/backup
mkdir /home/backup/bakmysqlold
mkdir /home/backup/bakmysql

检查有没安装crond,如果没有&＃xff0c;先安装

启动服务 :service crond start

在CentOS系统中加入开机自动启动: chkconfig --level 345 crond on

保存退出以后就可以了。

也许需要重启crontab  启用命令&＃xff1a;/sbin/service crond restart

后期更改~结果如下

12. 导出导入

导出&＃xff1a;

/usr/local/mysql/bin/mysqldump -u root -p123456 dbname > /bak/dbname.sql

进入mysql中创建一个数据库 dbname

/usr/local/mysql/bin/mysql -u root -p123456 dbname

-----------------------------------------------------------------------------------------------------------------

1.mongodb

创建独立用户&＃xff1a;
mongo
use ex8
db.createUser(
     {
       user:"ex8",
       pwd:"Asd&＃64;123456",
       roles:[{role:"dbOwner",db:"ex8"}]
     }
  )

测试登录
show users

mongo 127.0.0.1/ex8 -u ex8 -p Asd&＃64;123456

修改mongo用户密码

db.changeUserPassword(&＃39;ex8&＃39;,&＃39;12345678&＃39;);

mongodb数据库恢复:
mongodump -h 192.168.183.140 --port 27017 -u ex8 -p 12345678 -d ex8 -o  /home/tools   //导出ex8库到tools下
mongorestore -h 127.0.0.1 --port 27017 -u ex8 -p 12345678 -d ex8  /home/tools/ex8 //导入ex8库

2.mongodb自动备份&＃xff1a;

#touch /home/bakmongodb.sh

#vi /home/bakmongodb.sh

v_date&＃61;$(date &＃39;&＃43;%Y%m%d%H%M%S&＃39;)
/home/mongodb/bin/mongoexport -d ex8 -u ex8 -p 12345678 -c contentMongoEO -o /home/backup/mongo/mongo-$v_date.dat
gzip /home/backup/mongo/mongo-$v_date.dat
find /home/backup/mongo/ -name "mongo-*" -mtime &＃43;6 -exec rm -rf {} \;

#chmod -R 777 /home/bakmongodb.sh

#service crond start

#chkconfig --level 345 crond on

#crontab -e

0 2 * * * /home/bakmysql.sh# /sbin/service crond restart