Database Collation Fixer

Here is a little script i modified to help me fix wrong collation information in my joomla database it searchs for collation 1 and replaces with collation 2.

default setting is latin1_swedish_ci TO utf8_general_ci


all you have to do is upload the php file to your web root directory and edit the database details and then run the php file.

[code:1]// DB login information ( ONLY EDIT THIS SECTION NOTHING ELSE )
$username = 'username'; // enter the username to access your joomla Database
$password = 'password'; // enter the password to access your joomla Database
$database = 'database'; // enter the database name of your joomla Database
$host = 'localhost'; // enter the hostname of your mysql server ( normaly 'LOCALHOST' )
// DO NOT EDIT PAST HERE
[/code:1]

once it has finished it will list all the sql command you need to run on your database using PHPMYADMIN to correct all of the collations.

Post edited by: CerberusStyle, at: 2010/07/22 01:10

Post edited by: CerberusStyle, at: 2010/07/22 01:11

Post edited by: CerberusStyle, at: 2010/07/22 01:22

Thanks for sharing!

script being updated and will be unavailible for next few weeks.

Post edited by: CerberusStyle, at: 2010/07/27 01:39