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

This topic contains 2 replies, has 3 voices, and was last updated by  Sibin A S 1 year, 8 months ago.

  • Author
    Posts
  • #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.

  • #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

  • #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.

You must be logged in to reply to this topic.