PhpMyAdmin导入错误数据库

jdzmm42g  于 2022-11-09  发布在  PHP
关注(0)|答案(4)|浏览(221)

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!

xxhby3vn

xxhby3vn1#

有同样的问题;我的导入文件是未压缩的,所以我回去导出它gzip和导入是好的。

jbose2ul

jbose2ul2#

这也发生在我身上。在我的情况下,是导出的gzip文件出了问题。我下载了未压缩的文件,并在我的电脑上进行了gzip压缩,现在它工作了。

piah890a

piah890a3#

我也遇到了同样的问题,但原因是我的.sql文件是utf16编码的,而PhpMyAdmin中的默认设置是utf8。

dzhpxtsq

dzhpxtsq4#

我也遇到过同样的问题。但是在我的例子中,我的数据库是损坏的。所以我再次使用mysqldump命令&导入数据库,然后它开始工作。

mysqldump -u root -p database_name > "/home/databasename.sql"

相关问题