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

Lock Tables Fails

forums › forums › SQLyog › Using SQLyog › Lock Tables Fails

Tagged: 

  • This topic is empty.
Viewing 1 reply thread
  • Author
    Posts
    • November 18, 2015 at 5:58 pm #13445
      dbusr
      Participant

      I have sqlyog setup with a connection to databases on my computer (using WAMP) and another connection to a live server. If I upload a database (database->Import->SQL Script) to the local databases, it works fine. if I do the same for the live server, I get an access denied message. I’ve found that if I turn off the lock tables option when creating a backup, I can upload to the live server without any problems. So if I try the following it fails on the live server


      
CREATE TABLE `new_table` (
      
`id` int(11) NOT NULL AUTO_INCREMENT,
      
) ENGINE=InnoDB AUTO_INCREMENT=327 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
      

      
LOCK TABLES `new_table` WRITE;

      But if I remove the lock tables command, it works fine. My host says I have full access and that they are not aware of a reason this would fail. Does anyone know what the problem might be?

       

      Using sqlyog ultimate v12.16

    • November 20, 2015 at 12:11 pm #35552
      Kartik Grover
      Spectator

      We will follow up in our ticketing system where you have created a ticket.

  • Author
    Posts
Viewing 1 reply thread
  • You must be logged in to reply to this topic.