Change Database collation script

MySQL 7.3.2015 Comments Off on Change Database collation script

<?php
// your connection
mysql_connect(“localhost”,”root”,”notime”);
mysql_select_db(“medrek_test”);

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

by-

eLite Server Management

We Specialize In cPanel Server Management
Affordable 24/7 Technical Support Company

Comments are closed.