Issue
Cannot import SQL database extracted from Plesk web server backup. The following error is displayed in phpMyAdmin on the new server:
Static analysis:
...errors were found during analysis.
Unexpected character. (near "" at position...)
Resolution
The issue was caused by some binary data embedded into the .sql file. Deleting the binary data sections in a text editor and re-saving the file, resolved the issue.
November 2023
Plesk
phpMyAdmin
