• Oxford, Bicester
  • 01865 771011
  • 11:42
  • 0 Comments

I was recently importing our newest Oxford customer’s WordPress website to our web hosting system and hit a small issue while importing .sql database via phpMyAdmin. The import was failing with the following error:

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

The .sql database file was obtained from a Plesk web server backup. Opening the file in the Notepad++ text editor immediately made it obvious why the import was failing.

backup_sqldump

At the beginning and end of the file, there was a small section of some binary gibberish appearing as NUL inside Notepad++. Deleting these sections from the file resolved the issue.

Previous Post
Increase file upload limit on Plesk phpMyAdmin
Next Post
Duplicate WordPress site on another domain

Leave a Comment