Unsupported Screen Size: The viewport size is too small for the theme to render properly.

Forums | Webyog

Tools to manage and monitor MySQL databases

Lock a table in SQLyog

Tagged: sqlyog lock sync

This topic has 2 replies, 3 voices, and was last updated 5 years, 10 months ago by Aido.

Viewing 2 reply threads

Author

Posts
- December 18, 2017 at 6:20 am #36058
  
  salimali
  Participant
  
  Hi, One of the table in my database is locked. When i tried to change values for specific rows in that table, its resetting to the previous value. I can’t modify it. How can i change its settings ? Thanks in advance.
- December 18, 2017 at 7:21 am #36067
  
  Sibin A S
  Moderator
  
  Hi,
  
  Please execute ‘UNLOCK TABLES’ to release the lock acquired on the tables. You may refer the MySQL doc, here.
  
  Regards,
  Sibin
- August 14, 2019 at 7:18 pm #36235
  
  Aido
  Participant
  
  I met with the same issue. I am 100% sure that DB look locked for other transaction in the middle of the syncing process it happens every time and it becomes available again after synchronisation get finished.
Author

Posts

Viewing 2 reply threads

You must be logged in to reply to this topic.