PhpMyAdmin Import Errors Database

Question

When im trying to upload a DB i get the following error!

345 errors were found during analysis.

Unexpected character. (near ":" at position 230502) Unexpected character. (near ":" at position 230504) Unexpected character. (near "{" at position 230505) Unexpected character. (near ":" at position 230507) Unexpected character. (near ":" at position 230509) Unexpected character. (near ":" at position 230518) Unexpected character. (near ":" at position 230520) Unexpected character. (near ":" at position 230532) Unexpected character. (near ":" at position 230534) Unexpected character. (near ":" at position 230544) Unexpected character. (near ":" at position 230547) Unexpected character. (near ":" at position 230567) Unexpected character. (near ":" at position 230569) Unexpected character. (near ":" at position 230581) Unexpected character. (near ":" at position 230583) Unexpected character. (near ":" at position 230593) Unexpected character. (near ":" at position 230595) Unexpected character. (near ":" at position 230609) Unexpected character. (near "}" at position 230621) Unexpected character. (near ":" at position 230799) Unexpected character. (near ":" at position 230801) Unexpected character. (near "{" at position 230802) Unexpected character. (near ":" at position 230804) Unexpected character. (near ":" at position 230806) Unexpected character. (near ":" at position 230819) Unexpected character. (near ":" at position 230821) Unexpected character. (near ":" at position 230833) Unexpected character. (near ":" at position 230835) Unexpected character. (near ":" at position 230844)

I really don't know whats going on here!

Answer 1

Had the same issue; my import file was uncompressed so I went back and exported it gzipped and the import was fine.

Answer 2

This happened to me as well. In my case it was the gzipped file from the export that was the problem. I downloaded the uncompressed file and gzipped it on my computer, now it works.