WordPress 2.3 : a little note on Upgrade Process

This is easy upgrade process like previous versions.
But there are problems, this sign � shows up in blog posts.
Here is a way to fix it (same as search and replace contents in WordPress) :
1. Backup a WordPress database. You can use phpmyadmin or mysql console.
Using mysql console :

• mysqldump :
  mysqldump -u [username] -p [databasename] > [mysqlfile_name]
  example :
  mysqldump -u try -p nineteenlabs > /tmp/kate/backupfile01.sql
  output :
  Enter password : [type your password]

Using phpmyadmin :

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

2. Now, search and replace contents. This time i’ll do it in phpmyadmin, because this sign isn’t recognized in a console, �

• 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 ; its already fill by phpmyadmin in below box
• Push GO button. DONE!

SEARCH AND REPLACE THROUGH MYSQL CONSOLE WORKS IF ITEMS TO REPLACE IS EASY TO READ BY CONSOLE.

Using 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>use [database_name]
  mysql>(You want to make sure wp_posts table) show tables;
  mysql>+----------------------------+
| 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)
  mysql > UPDATE wp_posts SET post_content = REPLACE (post_content,'Item to replace','Replacement text');
  mysql > exit