一起讨论-CSDN博客

原创 Python搜索查找文件内容

#!/usr/bin/env python# -*- coding: utf-8 -*-# @Time : 2020/11/18 16:31# @Author : lumia98@vip.qq.com# @File : check# @Software: PyCharmimport ref = open('C:\\Users\super\Desktop\log\\16.txt', 'r', encoding='utf-8')for line in f: if re.

2020-11-23 14:15:06 2084

原创 Shell备份MySQL脚本

#!/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'#

2020-11-20 21:57:47 269

原创 MySQL启动脚本(改编官方启动脚本)

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的配置

2020-11-20 21:55:45 763

原创 MySQL主从复制(开启GTID)

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

2020-11-20 21:53:47 657

原创 MySQL全备增量备份(xtrabackup)

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所有

2020-11-20 21:51:56 609

原创 Python备份数据(适用于远程备份)

#!/usr/bin/env python3# -*- coding: utf-8 -*-"""通过paramiko从远处服务器下载文件资源到本地author: lumia98@vip.qq.comtime: 2020-01-02"""import paramikoimport osfrom stat import S_ISDIR as isdirfrom datetime import datetimedef down_from_remote(sftp_obj, remote_

2020-11-20 21:47:22 790

原创 Python批量导入Excel数据到MySQL

#!/usr/bin/env python# -*- coding: utf-8 -*-# @Time : 2020/11/20 14:30# @Author : lumia98@vip.qq.com# @File : Excel# @Software: PyCharmimport xlrdimport pymysqlclass Add_Excel_Data_To_MySQL(object): """ Excel表格数据批量导入到MySQL库 """

2020-11-20 21:43:56 1559

lumia98的博客