lumia98的博客

MySQL用GTID方式恢复数据1、先登录MySQL系统查看当前的binlog日志# 找到binlog文件路径mysql> show master status;# 查看gtid号，每个gtid号都在执行语句之前生成(切记)mysql> show binlog events in 'mysql-bin.000004' 2、开始导出数据[root@test ~]# mysqlbinlog --skip-gtids --include-gtids='b09afa63-11d5-1

#创建 for i in `cat /opt/txt.txt` do #/opt/txt.txt存放数据库名，一个库名一行 # $i是库名 # 创建数据库 mysql -uroot -p123456 -e "CREATE DATABASE $i;" done #恢复 for i in `cat /opt/txt.txt` do # $i是库名 #导入mysql数据库,请先备份 #sql文件存放路径/opt/data/$i.

#查所有据库的表大小（全部）select table_schema as '表名', table_name as '表名',table_rows as '记录数',truncate(data_length/1024/1024, 2) as '数据容量(MB)',truncate(index_length/1024/1024, 2) as '索引容量(MB)'from information_schema.tablesorder by data_length desc, index_length de.

#!/bin/bash# backup database# 备份MySQL# by liushexport PATH=/usr/local/sbin:/usr/local/bin:/usr/sbin:/usr/bin:/root/bin:/opt/app/mysql/dir/bin:/root/bin#备份开始时间#echo "start:" $(date +"%Y-%m-%d %H:%M:%S")# 数据库账号密码dbuser='root'dbpasswd='hao3q3'#

MySQL二进制及编译安装启动脚本[root@localhost ~]# more /etc/init.d/mysqld #!/bin/bash# MySQL启动脚本# by lumia98@vip.qq.com#安装目录basedir='/opt/app/mysql-3306'#MySQL的bin目录bindir='/opt/app/mysql-3306/bin'#MySQL数据存放目录datadir='/databases/mysql-3306/data'#MySQL的配置

MySQL二进制安装脚本(开启gtid)0、创建mysql目录脚本#!/bin/bash# mysql二进制安装脚本，也适用多实例# 创建安装目录basedir='/opt/app/mysql-3306' #mysql安装目录datadir='/databases/mysql-3306/data' #mysql数据存放目录etcdir=${basedir}/etc #my.cnf存放目录logdir=${basedir}/logs

MySQL通过xtrabackup备份及恢复数据安装xbk（ XtraBackup8.0开始不支持MySQL8.0之前的版本）# 下载地址，可以下载rpm等包https://www.percona.com/downloads/Percona-XtraBackup-LATEST/# dnf或yum安装dnf install percona-xtrabackup-80-8.0.14-1.el8.x86_64.rpm -yxbk备份的核心功能1、针对非innodb引擎表进行锁表备份，copy所有