← Back to team overview

maria-discuss team mailing list archive

New Question: Error exporting from MySQL to MariaDB



A new question has been asked in "MariaDB Documentation" by jayres. Please answer 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 running 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 corresponds to your MariaDB server version for the right syntax to use near ''<a href="/locations/about/" class="right-side-footer-link">About Us</a>&nbsp' at line 116

Apparently that is within this line in the db:
(405, 'woo_footer_right_text', '<a href="/locations/about/" class="right-side-footer-link">About Us</a>&nbsp;&nbsp;&nbsp;<a href="/contact/" class="right-side-footer-link">Contact Us</a>&nbsp;&nbsp;&nbsp;<a href="/appointments-bill-pay/medical-forms/" class="right-side-footer-link">Medical Forms</a><br /><a href="/legal/" class="right-side-footer-link">Legal</a>&nbsp;&nbsp;&nbsp;<a href="/sitemap/" class="right-side-footer-link">Sitemap</a>&nbsp;&nbsp;&nbsp;<a href="/professionals/partner-links/" class="right-side-footer-link">Partner Links</a>&nbsp;&nbsp;&nbsp;<a href="https://access.domain.com/+CSCOE+/logon.html"; class="right-side-footer-link" target="_blank">PACS Login</a>', 'yes'),

Is it the multiple non-breaking space codes? Do I need to escape them (and how 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/