开发者

MYSQL Import Failing because of `//`

I have a mysql file that seems to be breaking at some HTML/JS that is stored in the database.

Here are a few errors:

[ERROR in qu开发者_如何学运维ery 178] 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 '

and

[ERROR in query 179] 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 '}

// ]]>
</script>

<script src="./js/tooltip.js" type=' at line 1 [ERROR in query 180]

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 '} /* ]]> */

and

[ERROR in query 181] 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 'Table './web_cms_prod/wp_redirection_logs' is marked as crashed and should be re' at line 1

Its a wordpress database if that matters, not sure why someone is storing HTML in the database, but I need to get it imported nonetheless.

Any ideas? Can I escape it somehow? A SED unix command would be nice as its a 9 meg file.


It's probably not the // but some quotes that appear before it. You need to make sure that all of the quotes contained within your string values are escaped.

0

上一篇:

下一篇:

精彩评论

暂无评论...
验证码 换一张
取 消

最新问答

问答排行榜