Support » Fixing WordPress » Database Error

  • Resolved JoeLongstreet


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




Viewing 2 replies - 1 through 2 (of 2 total)
  • 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.

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

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

    Thanks again,


Viewing 2 replies - 1 through 2 (of 2 total)
  • The topic ‘Database Error’ is closed to new replies.