运行MySQLDump而不锁定表 [英] Run MySQLDump without Locking Tables

问题描述

我想将现场生产数据库复制到我的本地开发数据库中。有没有办法不锁定生产数据库？

I want to copy a live production database into my local development database. Is there a way to do this without locking the production database?

我目前正在使用：

mysqldump -u root --password=xxx -h xxx my_db1 | mysql -u root --password=xxx -h localhost my_db1

但是它会锁定每个表。

推荐答案

- lock-tables = false ？

根据手册页，如果你倾销InnoDB表，你可以使用 - 单事务选项：

According to the man page, if you are dumping InnoDB tables you can use the --single-transaction option:

--lock-tables, -l

Lock all tables before dumping them. The tables are locked with READ
LOCAL to allow concurrent inserts in the case of MyISAM tables. For
transactional tables such as InnoDB and BDB, --single-transaction is
a much better option, because it does not need to lock the tables at
all.

这篇关于运行MySQLDump而不锁定表的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！