本文主要向大家介绍了MySQL数据库之MySQLdump之single-transaction详解 ,通过具体的内容向大家展现,希望对大家学习MySQL数据库有所帮助。
MySQLdump之single-transaction详解
single-transaction
开启general log选项
查看目前general log的情况
mysql> show variables like ‘%general_log%‘;
+------------------+--------------------------------------------+
| Variable_name | Value |
+------------------+--------------------------------------------+
| general_log | OFF |
| general_log_file | /data/mysqldata/3306/general_statement.log |
+------------------+--------------------------------------------+
2 rows in set (0.00 sec)
开启general log的选项
mysql> set global general_log=on;
使用mysqldump命令:。
[mysql@racnode1 ~]$ /usr/local/mysql/bin/mysqldump -uro