Re: change collation on all existing databases, tables and columns

2005-07-07 Thread Gleb Paharenko
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 info

change collation on all existing databases, tables and columns

2005-07-07 Thread Florian Effenberger
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_c