PDA

View Full Version : Importing .sql files(Error) using heidiSQL


vampiro
12-29-2006, 07:49 PM
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?????

davidj
12-29-2006, 07:57 PM
i have not used that GUI before

it sounds like an error in the SQL file which you should be able to open in note pad to fix

i use this GUI. Get the lite version coz its free

http://www.sqlmanager.net/products/mysql/manager