Unable to import database dump: ERROR 1064 (42000)

Symptoms

Importing a dump in Plesk > Domains > example.com > Databases > database_name > Import Dump fails with the following error:

PLESK_ERROR: Unable to import the database_name dump:
Unable to restore database 'database_name'
ERROR 1050 (42S01) at line 29: Table 'table_name' already exists
(Error code 22)

OR

PLESK_ERROR: ERROR 1064 (42000) at line 3678: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '------WebKitFormBoundaryKlp0WRjldBLt0a4h
Content-Disposition: form-data' at line 1
(Error code 22)

The dump was created with the following end-line:

CONFIG_TEXT: ------WebKitFormBoundaryKlp0WRjldBLt0a4h
Content-Disposition: form-data; name="overwrite"
0

Cause

Database dump was created using a non-standard tool and has non-standard structure.

Resolution

1. Open the dump file with any text editor and remove the following line:

   CONFIG_TEXT: ------WebKitFormBoundaryKlp0WRjldBLt0a4h
   Content-Disposition: form-data; name="overwrite"
   0

2. Login to Plesk

3. Re-import the dump at Plesk > Domains > example.com > Databases > database_name > Import Dump

Additional information

Cannot restore MySQL dump: You have an error in your SQL syntax