From: Date: July 7 2005 9:45am
Subject: change collation on all existing databases, tables and columns
List-Archive: http://lists.mysql.com/mysql/186283
Message-Id: <42CCDDA4.7060509@arcor.de>
MIME-Version: 1.0
Content-Type: text/plain; charset=ISO-8859-15
Content-Transfer-Encoding: 7bit

Hello there,

I run MySQL 4.1.12 and have some databases with the default collation of
latin1_swedish_ci. I have edited the my.cnf file to read

default-collation = latin1_german1_ci

Now I would like to change the collation on all existing databases,
tables and columns to have the latin1_german1_ci collation, as the
my.cnf entry only works for new entries. Is there an easy command or
tool to achieve that? I don't want to send the appropriate command
mentioning every single database, table and column, but rather look for
a FOR loop or a wildcard.

Thanks
Florian