table stays LOCKED with import of sql dump

[Eng65]

My host went out of buisness, so i ended up with a load of Sql Dumps.
The upload of my site went fine until i tried import the Sql Dump. All i am getting now:

LOCK TABLES `PLD_CATEGORY` WRITE ;
MySQL said:
#1044 - Access denied for user @ Db...
Some guy suggeted removing the "LOCK TABLE" on the Sql file, but this already set to "UNLOCK" TABLES.

I think it is a permissions thing but i am not sure?

Appreciate some advice.
Thank you
Eng65

[ronverdonk]

Welcome to The Scripts!

Please remember to provide a meaningful Title for any threads started (see the FAQ entry Use a Good Thread Title).

This helps to ensure that other members, and also the general public, will have a better chance of finding answers to any similar questions.

MODERATOR

[amitpatel66]

My host went out of buisness, so i ended up with a load of Sql Dumps.
The upload of my site went fine until i tried import the Sql Dump. All i am getting now:

LOCK TABLES `PLD_CATEGORY` WRITE ;
MySQL said:
#1044 - Access denied for user @ Db...
Some guy suggeted removing the "LOCK TABLE" on the Sql file, but this already set to "UNLOCK" TABLES.

I think it is a permissions thing but i am not sure?

Appreciate some advice.
Thank you
Eng65

This access denied might be because some other session might have locked the table before you could and unles that session executes a ROLLBACK or COMMIT, the table will not get released.

[Eng65]

Thanks for your reply "Roll Back" "Commit" I am not to sure what you mean with this friend? Could you please be more specific.

Thank You
Regards,
Eng65

We all have to start some where, agree? I know you would