convert all collations (tables and rows) in a MySQL-DB to utf-8

mysql-recursive-convert-collation.php

<?php
// your connection
mysql_connect("localhost","root","");
mysql_select_db("");

// 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 />";
    }
}
?>

via: http://www.webhostingtalk.com/showpost.php?p=5032059&postcount=3