MySQL Forums
Forum List  »  InnoDB

Table Engine Innodb, but mysqldump add option --single-transaction always lock table it ?
Posted by: wenchao wenchao
Date: May 14, 2021 02:24AM

Please Help,

【Table Engine Innodb, but mysqldump add option --single-transaction always lock table it ?】

By MYSQL Version is mysql Ver 14.14 Distrib 5.7.33 ;
By MYSQLDUMP is MySQL dump 10.13 Distrib 5.7.33, for Linux (x86_64);


Run this command : mysqldump -h127.0.0.1 -P3306 -uroot -p --single-transaction --databases db01 --master-data=2 --quick > db01_bk.sql

Now:
One By One LOCK TABLES `table name` WRITE; and UNLOCK TABLES;


Thanks !

Options: ReplyQuote




Sorry, only registered users may post in this forum.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.