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.
精彩评论