Run it from remoto-it or just locally like in:
./mysql-change-collation-all-tables-db.sh mysql.sample.com root mydb utf8_unicode_ciI try to keep the same collation and charset across all db objects. So I make sure my database (table_schema) has the same collation as the tables it hosts:
show variables like "collation_database"; SELECT table_schema, table_name,table_collation FROM information_schema.tables where table_schema='myDB'; #show table status;
No comments:
Post a Comment