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
- 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> ' 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> <a href="/contact/" class="right-side-footer-link">Contact Us</a> <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> <a href="/sitemap/" class="right-side-footer-link">Sitemap</a> <a href="/professionals/partner-links/" class="right-side-footer-link">Partner Links</a> <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?
