Skip to content

Instantly share code, notes, and snippets.

@montalvomiguelo
Forked from sanjaybhowmick/dbconversion.php
Created June 19, 2016 20:51
Show Gist options
  • Save montalvomiguelo/fd6cbcb939e525e1dd85f7a0535528d2 to your computer and use it in GitHub Desktop.
Save montalvomiguelo/fd6cbcb939e525e1dd85f7a0535528d2 to your computer and use it in GitHub Desktop.
Convert MySQL collation from utf8mb4 to utf8
<?php
$dbname = 'your-database-name';
mysql_connect('your-database-hostname', 'your-database-username', 'your-database-password');
mysql_query("ALTER DATABASE `$dbname` DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci");
$result = mysql_query("SHOW TABLES FROM `$dbname`");
while($row = mysql_fetch_row($result)) {
$query = "ALTER TABLE {$dbname}.`{$row[0]}` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci";
mysql_query($query);
$query = "ALTER TABLE {$dbname}.`{$row[0]}` DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci";
mysql_query($query);
}
echo 'All the tables have been converted successfully';
?>
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment