WordPress.org

Ready to get started?Download WordPress

Forums

[resolved] Database Error (3 posts)

  1. JoeLongstreet
    Member
    Posted 5 years ago #

    I exported the database to move a wordpress blog, and when I imported it, I got some funny characters in the text. Any suggestions?

    blog: jenningspr.net/blogs

    Thanks,

    Joe

  2. stvwlf
    Member
    Posted 5 years ago #

    This frequently happens. If there are not many of them do it by hand.

    If there are a lot this procedure will help

    Removing garbled chars from all posts

    1) BACK UP YOUR DATABASE BEFORE YOU DO THIS. Have the backup zip file or SQL file in hand!

    2) This code assumes your tables use the default prefix of 'wp_'

    The way I fixed these was with copy and paste - copy one string of garbled characters and paste it into an SQL statement. More than likely if I paste garbled chars from your site this forum software will strip it out, so I am using x3!29* as a stand-in - where you see that, paste in one occurrence of garbled characters from your site. The code replaces all occurrences of that one garbled string with an empty string, i.e. removes the garbled and puts nothing in its place.

    You will run the code in phpMyAdmin, then refresh the website page in the browser. If there are further strings of garbled characters, paste the next combination into the SQL statement, and run the query again, until all the garbled characters are gone. The advantage of this method is running the statement once cleans up every occurrence of that string in every post on the site.

    UPDATE wp_posts SET post_content = replace(post_content, 'x3!29*', '');

    If you need instructions on how getting into and use phpMyAdmin, see this tutorial. Its about lost passwords. You don't care about the password part. The part to use is the part about getting into phpMyAdmin, and how to enter and run a SQL statement.

    http://codex.wordpress.org/Resetting_Your_Password#Through_phpMyAdmin

    Do remember to make that backup first! If you pay attention and work slowly everything will be fine.

  3. JoeLongstreet
    Member
    Posted 5 years ago #

    Thanks man, that worked perfectly! No problems what so ever.

    Thanks again,

    Joe

Topic Closed

This topic has been closed to new replies.

About this Topic