开发者

MYSQL Import Failing because of `//`

开发者 https://www.devze.com 2023-03-18 23:15 出处:网络
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:

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

精彩评论

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