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]
