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
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