Importing posts from Blogger to self-hosted WordPress adds > to article title

  • Hi everyone,

    I have a blog at https://patscompservices.blogspot.com and am creating a site at https://patscomputerservices.com (which isn’t configured at the moment). In order to prep for this, I’ve installed WordPress on a virtual machine on my local network, so I can configure everything and then move it to it’s permanent home.

    The issue that I’m having is when I imported all of my blog posts from the blogspot.com site into my local wordpress install, it added a > at the beginning of every title.

    For example, I have a post called “Moving to a new site” on my blog. When I imported it, WordPress called it “>Moving to a new site”.

    My questions are, what can I do to eliminate the >? And will I be able to re-import them after fixing that, or will I have to manually edit 200+ posts to remove the >? (Question 1 is important for when I actually create my site on my host. Question 2 is important if Question 1 isn’t an option or if it fails to work.)

    Thanks, and have a great weekend. ??
    Patrick.

Viewing 3 replies - 1 through 3 (of 3 total)

  • Hi Patrick,

    Login to your PhpMyAdmin, select the database in question and click on SQL. Enter the below syntax:

    UPDATE wp_posts SET post_title = REPLACE(post_title, '>', '');

    This should replace all the > characters in the title with no space at all.

    P.S. If you have changed the table prefix in WordPress, then instead of wp_posts enter a different table name, such as [newprefix]_posts.

    Hope it helps.

    Thread Starter patrickdickey

    (@patrickdickey)

    Thanks Johnb81. I’ll try that later. I’m not too worried about it, as it’s only an internal blog. I was more worried, because I’m migrating from blogspot to a hosted website using WordPress. Thankfully, that issue didn’t happen in the migration.

    I wonder what causes it in localhost (or local machine) installs, but not in the 1-click installs on sites like DreamHost and HostGator. Something for the devs to look into, maybe.

    Have a great day. ??
    Patrick.

    Let us know how it went.

    Usually it happens because of encoding differences between the source and the remote database.

Viewing 3 replies - 1 through 3 (of 3 total)
  • The topic ‘Importing posts from Blogger to self-hosted WordPress adds > to article title’ is closed to new replies.

Tags