# innobackupex-1.5.1 with "--no-lock" option

**URL:** <https://forums.percona.com/t/innobackupex-1-5-1-with-no-lock-option/2108>\
**Category:** Percona XtraBackup\
**Created:** [December 10, 2010, 2:25am UTC](https://forums.percona.com/t/innobackupex-1-5-1-with-no-lock-option/2108 "2010-12-10T02:25:35Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![hiroshi](https://avatars.discourse-cdn.com/v4/letter/h/b5ac83/32.png) [@hiroshi](https://forums.percona.com/u/hiroshi)\
**Post date:** [December 10, 2010, 2:25am UTC](https://forums.percona.com/t/innobackupex-1-5-1-with-no-lock-option/2108/1 "2010-12-10T02:25:35Z")

</div>

Hello,

Usually innobackupex-1.5.1 needs to execute “FLUSH TABLES WITH READ LOCK” to lock to the whole MySQL server. But I don’t want to lock MySQL during backup. The xtrabackup command can backup InnoDB tables without locking, but it doesn’t copy .frm file to restore tables. So I have to backup .frm file separately.

innobackupex-1.5.1 with “–no-lock” option could backup the data without locking, but I’m not sure it is okay. About data consistency, Backup without lockgin is no proble because all tables are InnoDB. However I don’t know whether or not I copy .frm files without closing those tables using “FLUSH TABLES WITH READ LOCK”.

Could I use innobackupex with “–no-lock” if I’ll backup only InnoDB tables?

Regards,

Hiroshi

---

<div class="post-metadata">

**Author:** ![xaprb](https://avatars.discourse-cdn.com/v4/letter/x/49beb7/32.png) [@xaprb](https://forums.percona.com/u/xaprb)\
**Post date:** [December 14, 2010, 1:07pm UTC](https://forums.percona.com/t/innobackupex-1-5-1-with-no-lock-option/2108/2 "2010-12-14T13:07:09Z")

</div>

Yes, you can do that.

---

<div class="post-metadata">

**Author:** ![hiroshi](https://avatars.discourse-cdn.com/v4/letter/h/b5ac83/32.png) [@hiroshi](https://forums.percona.com/u/hiroshi)\
**Post date:** [December 16, 2010, 2:02am UTC](https://forums.percona.com/t/innobackupex-1-5-1-with-no-lock-option/2108/3 "2010-12-16T02:02:38Z")

</div>

OK. Thanks, xaprb

Regards,

hiroshi
