I tried backing up and restoring my WP site to a different location. Inside the backup SQL file the posts contain HTML with carriage returns escaped:
However after the restore, these now appear inside the posts as literal strings, so the output to the page is now...
Some text \r\n some more text
Did I chose the wrong restore option or is there a WP setting I missed somewhere? Note. The Db is MariaDb. Everything else seems to have restored perfectly.