What are the exact commands you use to create the backup and to restore it?

for taking dump:
mysqldump -p -u root --single-trasaction DBName > filepath.sql

for resotration:

mysql -p -u root DBName1 < filepath.sql

Can you look at the line in "filepath.sql" identified by the error message, and see what's there?

restoration stop at table "TBL_EVENT_SUBMISSION_QUEUE"

And this table desc is


+------------------------+-------------+------+-----+------- --+----------------+
| Field | Type | Null | Key | Default | Extra |
+------------------------+-------------+------+-----+------- --+----------------+
| FLD_QUEUE_ID | int(11) | NO | PRI | NULL | auto_increment |
| FLD_ADD_DATE_TIME | datetime | NO | | NULL | |
| FLD_LAST_TRY_DATE_TIME | datetime | YES | | NULL | |
| FLD_TRY_COUNT | int(11) | YES | | NULL | |
| FLD_SUBMIT_DATA | blob | YES | | NULL | |
| FLD_QUEUE_STATUS | smallint(6) | YES | | NULL | |
| FLD_REMARKS | text | YES | | NULL | |
+------------------------+-------------+------+-----+------- --+----------------+


I again restored data this time it showing error.

ERROR at line 18924: Unknown command '\''.I think blob Type creating problem.

If that's the case, then the --hex-blob option to mysqldump might help.