Welcome to OGeek Q&A Community for programmer and developer-Open, Learning and Share
Welcome To Ask or Share your Answers For Others

Categories

0 votes
507 views
in Technique[技术] by (71.8m points)

使用phpmyadmin备份数据库后导入时出现了问题

各位大神,我通过WordPress创建了一个网站(在自己电脑上),并且用phpmyadmin软件将数据库导出为.sql文件,当我复制.sql文件里面的代码到navicat并执行的时候显示如下错误(部分代码,其他错误和下面代码相似):

1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '
border-left-style:solid' at line 1
1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '
background-image:none' at line 1

这些错误的代码集中在一起,并不是零散的出现,其他代码可以正常执行。
上面的错误导致我网站里面的几篇文章消失了,请问大神们,这种情况怎么解决啊?
有没有什么办法可以备份数据库然后还可以完完整整的还原呢?复制数据库的文件夹可以吗?
谢谢!


与恶龙缠斗过久,自身亦成为恶龙;凝视深渊过久,深渊将回以凝视…
Welcome To Ask or Share your Answers For Others

1 Reply

0 votes
by (71.8m points)

你可以本地也连接navicat 利用里面的工具 右键数据库-》数据库传输


与恶龙缠斗过久,自身亦成为恶龙;凝视深渊过久,深渊将回以凝视…
OGeek|极客中国-欢迎来到极客的世界,一个免费开放的程序员编程交流平台!开放,进步,分享!让技术改变生活,让极客改变未来! Welcome to OGeek Q&A Community for programmer and developer-Open, Learning and Share
Click Here to Ask a Question

...