Announcement

Collapse
No announcement yet.

Lock All Table option in Backup

Collapse
X
  • Filter
  • Time
  • Show
Clear All
new posts

  • Lock All Table option in Backup

    I try to backup a MySQL 5.0 database. I find there is a Lock All Table option. What is the reason to enable it during backup? Will the backup process cause any problems if I don’t enable it?

  • #2
    If you do not enable Lock All Tables option and a user is making changes to a table, it may lost data during backup. If you enable Lock All Tables option, other operations on that server dealing with that table will be blocked until backup is finished.

    For more information, you can refer to -
    http://dev.mysql.com/doc/refman/5.0/en/lock-tables.html

    Comment

    Working...
    X