I have been using heidiSQL to import a .sql file. On the toolbar, it has the option Import-Load SQL-file.
Once that step is complete, I click on the execute sql button which then brings up an error message, "SQL Error: Table 'time_zone_name' was not locked with LOCK TABLES
I am however unsure if I am supposed to execute the file after loading it since it does not display any tables or any data.
I have also been working on navicat which allows for more files types to be imported including access but .sql is not in their list.
Where could I be going wrong?
could somebody help out?????
Once that step is complete, I click on the execute sql button which then brings up an error message, "SQL Error: Table 'time_zone_name' was not locked with LOCK TABLES
I am however unsure if I am supposed to execute the file after loading it since it does not display any tables or any data.
I have also been working on navicat which allows for more files types to be imported including access but .sql is not in their list.
Where could I be going wrong?
could somebody help out?????