[Maria-discuss] New Question: Error exporting from MySQL to MariaDB
Hello, 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> ' 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?) -------------------------------- To view or answer this question please visit: http://mariadb.com/kb/en/error-exporting-from-mysql-to-mariadb/
participants (1)
-
AskMonty KB