mysqldump原理和重要参数
发布日期:2021-11-08 09:37:41
浏览次数:1
分类:技术文章
本文共 2853 字,大约阅读时间需要 9 分钟。
1. 开启general_log set global general_log=1 show gloabal variables like '%general%'; 2.执行备份 mysqldump --master-data=2 --single-transaction -A > db.sql 参数解释: --master-data=2 :备份出来的sql语句里面 change master 带上注释了 --single-transaction : 设置事务的隔离级别为可重复读repeatable read,如果其他innodb引擎的线程修改了表的数据并提交,对该dump线程的数据并无影响 dump-slave :从库上dump数据 set-gtid-purged=OFF|ON : 是否需要GTID的信息 3.查看general_log日志 connect root@localhost on using socket query /*!40100 set @@sql_mode='' */ query /*!40103 set time_zone='+00:00' */ query flush /*!40101 local */ tables query flush tables with read lock query set session transaction isolation level repeatable read #3 query start transaction /*!40100 with consistent snapshot */ #4 query show variables like 'gtid\_mode' query select @@global.gtid_executed #5 query show master status #6 query unlock tables #7 query show databases #8 query show variables like 'ndbinfo\_version' init db adminsql query show create database if not exists `adminsql` #9 query savepoint sp #10 query show tables query show table status like 'auth\_group' #11 query set sql_quote_show_create=1 query set session character_set_results = 'binary' #12 query show create table `auth_group` #13 query set session character_set_results = 'utf8' #14 query show fields from `auth_group` query show fields from `auth_group` query select /*!40001 sql_no_cache */ * from `auth_group` #15 query set session character_set_results = 'binary' query use `adminsql` query select @@collation_database query show triggers like 'auth\_group' query set session character_set_results = 'utf8' query rollback to savepoint sp #16 query show table status like 'auth\_group\_permissions' query set sql_quote_show_create=1 query set session character_set_results = 'binary' query show create table `auth_group_permissions` query set session character_set_results = 'utf8' query show fields from `auth_group_permissions` query show fields from `auth_group_permissions` query select /*!40001 sql_no_cache */ * from `auth_group_permissions` query set session character_set_results = 'binary' query use `adminsql` query select @@collation_database query show triggers like 'auth\_group\_permissions' query set session character_set_results = 'utf8' ...... query rollback to savepoint sp query show table status like 'mysql\_tables' query set sql_quote_show_create=1 query set session character_set_results = 'binary' query show create table `mysql_tables` query set session character_set_results = 'utf8' query show fields from `mysql_tables` query show fields from `mysql_tables` query select /*!40001 sql_no_cache */ * from `mysql_tables` query set session character_set_results = 'binary' query use `adminsql` query select @@collation_database query show triggers like 'mysql\_tables' query set session character_set_results = 'utf8' query rollback to savepoint spqueryrelease savepoint sp
转载地址:https://blog.csdn.net/zhengwei125/article/details/76906707 如侵犯您的版权,请留言回复原文章的地址,我们会给您删除此文章,给您带来不便请您谅解!
发表评论
最新留言
能坚持,总会有不一样的收获!
[***.219.124.196]2024年03月24日 00时23分19秒
关于作者
喝酒易醉,品茶养心,人生如梦,品茶悟道,何以解忧?唯有杜康!
-- 愿君每日到此一游!
推荐文章
java 减少内存_java中减少内存占用小技巧
2019-04-21
centos 7 mysql图形界面_centos7-vnstat图形界面搭建
2019-04-21
java 防渗透_「java、工程师工作经验怎么写」-看准网
2019-04-21
java中跳出当前循环怎么做_在java中,如何跳出当前的多重循环?
2019-04-21
java16下载_java lombok下载
2019-04-21
python 图像处理与识别书籍_Python图像处理之识别图像中的文字(实例讲解)
2019-04-21
java安全初始化_java安全编码指南之:声明和初始化
2019-04-21
java jstat gc_分析JVM GC及内存情况的方法
2019-04-21
php linux权限,Linux权限详细介绍
2019-04-21
典型环节的matlab仿真分析,典型环节的MATLAB仿真.doc
2019-04-21
Php contenttype类型,各种类型文件的Content Type
2019-04-21
php使用redis持久化,redis如何持久化
2019-04-21
php7.1解压包安装,【Swoole】php7.1安装swoole扩展
2019-04-21
linux centos删除安装的包,CentOS yum认为已删除的软件包仍在安装中
2019-04-21
酒店管理系统c语言带注释,酒店管理系统--C语言版.pdf
2019-04-21
c语言 实现sizeof功能,C语言简单实现sizeof功能代码
2019-04-21