Pixel Insert

I saw unknown symbols, such as � show up in blog posts.
There is a way to fix it. The method is search and replace contents in WordPress via phpMyAdmin or MySQL Console

1. Backup the  WordPress database.
MySQL console :

• mysqldump :

  mysqldump -u [username] -p [databasename] > [mysqlfile_name]

  example :

  mysqldump -u try -p px > /tmp/kate/backupfile01.sql

  output :
  Enter password : [type your password]

phpMyAdmin :

• Choose Database
• Choose Export tab
• Options : Export SQL, Structure Add DROP TABLE / DROP VIEW, check Save as File and push Go button

2. Ssearch and replace content via phpMyAdmin. Console cannot recognized symbols, �

• Choose Database
• Choose table wp_posts (click wp_posts in left bar)
• Choose SQL tabs
• Type this inside Run SQL query/queries on database box :

  UPDATE wp_posts SET post_content = REPLACE (post_content,'�',' ')

  note : without delimiter ;

• Push GO button. DONE!

SEARCH AND REPLACE VIA MYSQL CONSOLE ONLY WORK FOR ITEMS RECOGNIZED BY CONSOLE.

mySQL Console

• log in to mySQL Console

  mysql -u [username] -p
  Enter password : [type your password]
  Welcome to the MySQL monitor. Commands end with ; or \g.
  Your MySQL connection id is xxx to server version: x.x.x��
  Type 'help;' or '\h' for help. Type '\c' to clear the buffer.
  
  mysql><code>use [database_name]</code>
  mysql>(You want to make sure wp_posts table) <code>show tables;</code>
  mysql><code>+----------------------------+
  | Tables_in_wordpress |
  +----------------------------+
  | wp_comments |
  | wp_falbum_cache |
  | wp_links |
  | wp_liveshoutbox |
  | wp_liveshoutbox_useronline |
  | wp_options |
  | wp_podpress_statcounts |
  | wp_podpress_stats |
  | wp_postmeta |
  | wp_posts |
  | wp_term_relationships |
  | wp_term_taxonomy |
  | wp_terms |
  | wp_usermeta |
  | wp_useronline |
  | wp_users |
  +----------------------------+
  16 rows in set (0.00 sec)</code>
  mysql > <code>UPDATE wp_posts SET post_content = REPLACE (post_content,'Item to replace','Replacement text');</code>
  mysql > <code>exit</code></li>
  

Related posts:

1. Downgrade WordPress
2. Transfer WordPress Blog and Database from server to server
3. Upgrade WordPress
4. Enable Linked Table in phpMyAdmin
5. Transfer Cpanel accounts from server to server