From noreply@askmonty.org Thu Nov 19 19:09:38 2015 From: AskMonty KB To: discuss@lists.mariadb.org Subject: [Maria-discuss] New Question: Error exporting from MySQL to MariaDB Date: Thu, 19 Nov 2015 19:10:04 +0000 Message-ID: <20151119191004.3297.84910@kb01.mariadb.com> MIME-Version: 1.0 Content-Type: multipart/mixed; boundary="===============5615825362709170827==" --===============5615825362709170827== Content-Type: text/plain; charset="utf-8" Content-Transfer-Encoding: quoted-printable Hello, A new question has been asked in "MariaDB Documentation" by jayres. Please an= swer it at http://mariadb.com/kb/en/error-exporting-from-mysql-to-mariadb/ as= the person asking the question may not be subscribed to the mailing list. -------------------------------- I am attempting to move a wordpress db from a server running MySQL to one run= ning MariaDb. It stops and throws this error: 2 errors were found during analysis. Ending quote ' was expected. (near "" at position 16695) 4 values were expected, but found 3. (near "(" at position 16587) SQL query: Documentation #1064 - You have an error in your SQL syntax; check the manual that correspon= ds to your MariaDB server version for the right syntax to use near '' ' at= line 116 Apparently that is within this line in the db: (405, 'woo_footer_right_text', 'About Us
&nb= sp; Partner Links ', 'yes'), Is it the multiple non-breaking space codes? Do I need to escape them (and ho= w to escape them for MariaDb) or replace them (if so, with what?) -------------------------------- To view or answer this question please visit: http://mariadb.com/kb/en/error-= exporting-from-mysql-to-mariadb/ --===============5615825362709170827==--