Hello.
If you don't want to write a script (I think it shouldn't be difficult anyway)
for this purposes, you could use mysqldump with
--skip-create-options or --compatible=no_table_options,no_field_options.
Using this you could get the dump of you database and table definitions
without information about collation. Then just import the dump and all
tables will have the same collation. However, you can loose some
important table properties.
Florian Effenberger <[EMAIL PROTECTED]> wrote:
> 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
>
--
For technical support contracts, goto https://order.mysql.com/?ref=ensita
This email is sponsored by Ensita.NET http://www.ensita.net/
__ ___ ___ __
/ |/ /_ __/ __/ __ \/ /Gleb Paharenko
/ /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED]
/_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.NET
<___/ www.mysql.com
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
