Tables got locked when we try to import table data from mysql dump file

[Nishit kumar]

I am trying to import a dump file which consists of a table with its data c_emailnotificationtemplate which was generated by this command :-

mysqldump --host=10.88.129.238 --user=root --password client_1002 c_emailnotificationtemplate --single-transaction --set-gtid-purged=OFF > c_emailnotificationtemplate.sql

But when I am trying to import this c_emailnotificationtemplate.sql to my database , my database gets locked , I am not able perform any query also data is not get inserted on the table.

I tried to add --skip-lock-tables on the command but it doesn't work

so is there any way I can skip the lock operation which is happening when I am trying to import the sql file.

some details database:- client_1002
tablename:- c_emailnotificationtemplate
db instance :- gcp cloud sql (mysql8)