Title: clyphox's Replies | WordPress.org

---

# clyphox

  [  ](https://wordpress.org/support/users/clyphox/)

 *   [Profile](https://wordpress.org/support/users/clyphox/)
 *   [Topics Started](https://wordpress.org/support/users/clyphox/topics/)
 *   [Replies Created](https://wordpress.org/support/users/clyphox/replies/)
 *   [Reviews Written](https://wordpress.org/support/users/clyphox/reviews/)
 *   [Topics Replied To](https://wordpress.org/support/users/clyphox/replied-to/)
 *   [Engagements](https://wordpress.org/support/users/clyphox/engagements/)
 *   [Favorites](https://wordpress.org/support/users/clyphox/favorites/)

 Search replies:

## Forum Replies Created

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

 *   Forum: [Plugins](https://wordpress.org/support/forum/plugins-and-hacks/)
    In
   reply to: [[WP Migrate Lite - Migration Made Easy] [Plugin: WP Migrate DB] Messed up characters post migration](https://wordpress.org/support/topic/plugin-wp-migrate-db-messed-up-characters-post-migration/)
 *  Thread Starter [clyphox](https://wordpress.org/support/users/clyphox/)
 * (@clyphox)
 * [13 years, 11 months ago](https://wordpress.org/support/topic/plugin-wp-migrate-db-messed-up-characters-post-migration/#post-2570788)
 * What ever the issue with this plugin is I’ve just had to give up on it.
    I had
   to do an emergency migration and its totally fudged all the posts up again, I’ve
   at least had success the old fasioned way:
 *     ```
       mysqldump origdb > wp_orig.sql
       cp wp_orig.sql wp_new.sql
       perl -pi -e "s+old.domain.com+new.domain.com+g" wp_new.sql
       perl -pi -e "s+/public/sites/oldpath+/public/sites/newpath+g" wp_new.sql
       # assuming the destination DB and grants are ready just drop it and re_create it with the new variables
       mysql -e "drop database newdb;"
       mysql -e "CREATE DATABASE newdb DEFAULT CHARACTER SET utf8;"
       mysql -uliveusername -plivepassword newdb <~/wp_new.sql
       ```
   
 * NB: the perl does a search/replace on a file..
    I also use it on all files containing
   matches.. so hard-coded .xml files for some plugins for example sometimes need
   this.
 * To find a list of files that need changing:
    `find /path/to/search -type f -exec
   grep -l <string> {} \;`
 *   Forum: [Plugins](https://wordpress.org/support/forum/plugins-and-hacks/)
    In
   reply to: [[WP Migrate Lite - Migration Made Easy] [Plugin: WP Migrate DB] Messed up characters post migration](https://wordpress.org/support/topic/plugin-wp-migrate-db-messed-up-characters-post-migration/)
 *  Thread Starter [clyphox](https://wordpress.org/support/users/clyphox/)
 * (@clyphox)
 * [14 years ago](https://wordpress.org/support/topic/plugin-wp-migrate-db-messed-up-characters-post-migration/#post-2570784)
 * Yes I “think” the trick is to always ensure that your new wordpress databases
   always have the same character set/collation:
 * `CREATE DATABASE mydb DEFAULT CHARACTER SET utf8 DEFAULT COLLATE utf8_general_ci;`
 * Its still a mystery to me why [the official wordpress installation docs](http://codex.wordpress.org/Installing_WordPress)
   exclude this. Maybe I’m wrong :/
 * ericson, if you’re still in a spot of trouple try this route:
    [http://wordpress.org/extend/plugins/utf-8-db-converter/](http://wordpress.org/extend/plugins/utf-8-db-converter/)
   followed by creating the the new DB in utf etc: [http://www.rhyous.com/2009/11/05/how-to-create-a-utf-8-unicode-database-on-mysql/](http://www.rhyous.com/2009/11/05/how-to-create-a-utf-8-unicode-database-on-mysql/)
 * -good luck
 *   Forum: [Plugins](https://wordpress.org/support/forum/plugins-and-hacks/)
    In
   reply to: [[WP Migrate Lite - Migration Made Easy] [Plugin: WP Migrate DB] Messed up characters post migration](https://wordpress.org/support/topic/plugin-wp-migrate-db-messed-up-characters-post-migration/)
 *  Thread Starter [clyphox](https://wordpress.org/support/users/clyphox/)
 * (@clyphox)
 * [14 years, 2 months ago](https://wordpress.org/support/topic/plugin-wp-migrate-db-messed-up-characters-post-migration/#post-2570735)
 * I may need to do some tests to verify if this is maybe related to different collation
   on the DB itself :/ <throws hands up in air>

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