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

Lock a table in SQLyog

forums › forums › SQLyog › SQLyog Comments › Lock a table in SQLyog

Tagged: 

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.