Wordpress Export Import Site Escaped Character Challenges - " | MyThinkPond

When you export a Wordpress site and import the site into a new Wordpress site you will notice that a few HTML entities that are not allowed in an XML output got escaped. In simple terms, you will see a lot of " and if you use a Mac OSx system, your will see - “ and ” displayed as content in your blog pages.

Well here’s a way to correct them.

  1. Identify a list of these escaped XML entities using the HTML Entities Table. For most folks it would be just "

  2. Within your hosting environment, find out how to get to a MySQL query window to run your SQL commands.

  3. Backup your current database. And know how to restore it. (I am not liable).

  4. Run the following SQL command:

[sourcecode]

UPDATE wp_posts SET post_content= REPLACE(post_content, ‘"’, ‘“’); UPDATE wp_posts SET post_content=REPLACE(post_content, ‘<’, ‘<‘); UPDATE wp_posts SET post_content=REPLACE(post_content, ‘>’, ‘>’);

[/sourcecode]

Here in this example, I’m replacing all occurrences of &quot; with a double-quote. Now load up a sample blog article and verify that the issue is resolved.

Repeat steps-4 for each escaped HTML entity.

Now you’re all set to begin blogging with your newly imported WordPress blog. Happy Blogging!

Venkatt Guhesan avatar
About Venkatt Guhesan
Enterprise Software Architect currently working at DataDirect Networks developing a highly scalable monitoring solution called DDN Insight. My passions include all things Open Source including Linux (CentOS, Red Hat, Gentoo, Open Stack, Docker & Ubuntu), embedded ARM processors and microcontrollers (Arduino, UDOO, Cubieboard, BeagleBoard, OnionIO, TI's Zigbee). Coming from an Electrical and Computer Engineering background, working in developing and designing enterprise - distributed, highly scalable software requires a unique set of software skills with a good understanding of the hardware. This makes his work challenging and interesting. In his free time, he spends his time with his family and two children. He also enjoys researching on topics including - world ancient history and yoga. Visit the 'About' section for more details.
comments powered by Disqus