Title: Database Error
Last modified: August 19, 2016

---

# Database Error

 *  Resolved [joelongstreet](https://wordpress.org/support/users/joelongstreet/)
 * (@joelongstreet)
 * [17 years, 1 month ago](https://wordpress.org/support/topic/database-error-35/)
 * 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

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

 *  [stvwlf](https://wordpress.org/support/users/stvwlf/)
 * (@stvwlf)
 * [17 years, 1 month ago](https://wordpress.org/support/topic/database-error-35/#post-1065588)
 * 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](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.
 *  Thread Starter [joelongstreet](https://wordpress.org/support/users/joelongstreet/)
 * (@joelongstreet)
 * [17 years, 1 month ago](https://wordpress.org/support/topic/database-error-35/#post-1065882)
 * Thanks man, that worked perfectly! No problems what so ever.
 * Thanks again,
 * Joe

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

The topic ‘Database Error’ is closed to new replies.

## Tags

 * [sql-error](https://wordpress.org/support/topic-tag/sql-error/)
 * [strange characters](https://wordpress.org/support/topic-tag/strange-characters/)

 * In: [Fixing WordPress](https://wordpress.org/support/forum/how-to-and-troubleshooting/)
 * 2 replies
 * 2 participants
 * Last reply from: [joelongstreet](https://wordpress.org/support/users/joelongstreet/)
 * Last activity: [17 years, 1 month ago](https://wordpress.org/support/topic/database-error-35/#post-1065882)
 * Status: resolved

## Topics

### Topics with no replies

### Non-support topics

### Resolved topics

### Unresolved topics

### All topics