@celia Review the routes in your local instance. if you use WP-CLi you can do a search and replace of the path of your domain by the url of your local environment.
@lordvalor I can fix the paths. The emojis are a problem though, the example source was just to demonstrate what the emoji looks like in the source code, sorry! 😅
@celia it's because data is stored within the database and it munges things up if you're using utf8. To have emojis work, you need to use utf8mb4.
Having said the above, I've never been able to get it to work successfully when doing an import, so I've just reduced the number of emojis I use instead.
@celia by encoding your DB in urf8mb4 and ensuring your export is encoded the same way, it should work.
Problem I have is that I use Plesk on my web server, and it uses standard utf8 when creating a new DB, so it always messes up. There is a work around, but I haven't got around to implementing it yet.
@celia just thinking aloud here...wondering if, as well as a “proper” backup, it’s worth installing something like WP2Static and have it generate a static version of the site, then offload that somewhere. That way, there’s no DB and in a disaster (hopefully that won’t happen) you will have a like for like version of your site that you can publish.
You then have the formatted content, which should make fixing WP DB easier.
Fosstodon is an English speaking Mastodon instance that is open to anyone who is interested in technology; particularly free & open source software.