Convert MySQL character set and collations to utf8_unicode_ci

convertdb.php

<?php
/**
 * Convert MySQL tables to utf8_unicode_ci
 */

// Prevent accidental execution
die("Please open and update this file before executing it :)");

// Your connection
mysql_connect("localhost","development","development");
mysql_select_db("your-database-name");

// Convert code
$res = mysql_query("SHOW TABLES");
while ($row = mysql_fetch_array($res)){
  foreach ($row as $key => $table){
    mysql_query("ALTER TABLE " . $table . " CONVERT TO CHARACTER SET utf8 COLLATE utf8_unicode_ci");
    echo $key . " =&gt; " . $table . " CONVERTED<br />";
  }
}