Can’t import SQL dump from Plesk backup – Unexpected character near…

Issue

Cannot import SQL database extracted from Plesk web server backup. The following error is displayed in phpMyAdmin:

errors were found during analysis.

Static analysis:
…errors were found during analysis.
Unexpected character. (near “” at position…)

Resolution

The issue was caused by some binary data embedded into at the beginning and the end of the .sql file. Deleting the binary data sections in a text editor and re-saving the file, resolved the issue.

November 2023
Plesk
phpMyAdmin


Comments

Leave a Reply

Your email address will not be published. Required fields are marked *