Server Gigabit Guide

How to change all MySQL database table collation

You are here:
Estimated reading time: 1 min

After change the collation of a database, only the new tables will be created with the new collation. To change all the database collation, you can use the php script as below as it can change all the collation for all the existing table.

<?php
$db = mysql_connect(‘localhost’,’database_user‘,’Password‘);
if(!$db) echo “Cannot connect to the database – incorrect details”;
mysql_select_db(‘database_name‘); $result=mysql_query(‘show tables’);
while($tables = mysql_fetch_array($result)) {
foreach ($tables as $key => $value) {mysql_query(“ALTER TABLE $value COLLATE Collation“);
}}
echo “The collation of your database has been successfully changed!”;
?>

Note: 
database_user : Database Username
Password: Database user password
database_name: Database Name
Collation : new collation

You’ve successfully completed the steps to change the database table collation.If you found this guide useful during the setup of your additional address. Please share it with other users going through the same process.

 

Please refer to the following article to know more. 
Knowledge Base: How to delete MySQL database in WebsitePanel

Was this article helpful?
Dislike 0
Views: 69