The Ultimate Guide to High Availability with MariaDB
This is a read-only copy of the MariaDB Knowledgebase generated on 2024-11-16. For the latest, interactive version please visit https://mariadb.com/kb/.

Error exporting from MySQL to MariaDB

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

  1. 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?)

Answer Answered by Sergei Golubchik in this comment.

How did you generate the dump? There is no differences between MySQL and MariaDB in this regard, the dump should work identically for both. Or not work for both. May be your dump is corrupted, somehow?

Content reproduced on this site is the property of its respective owners, and this content is not reviewed in advance by MariaDB. The views, information and opinions expressed by this content do not necessarily represent those of MariaDB or any other party.