Alter all tables in MySQL

Answer:

To alter all the tables in a given database in MySQL, e.g. change the storage engine, you can first generate the SQL statements using following method.

mysql> select CONCAT("Alter Table `", TABLE_SCHEMA,"`.`", TABLE_NAME, "` ENGINE = InnoDB") AS cmd from TABLES where TABLE_SCHEMA = "test";

It will print out the followings:

+----------------------------------------------------------------+
| cmd                                                            |
+----------------------------------------------------------------+
| Alter Table `test`.`foo`  ENGINE = InnoDB                      | 
| Alter Table `test`.`bar`  ENGINE = InnoDB                      | 
...

Then you can execute the above commands manually.

Updated the Slave binary log if the updates are received from a MySQL master

Answer:

When the updates are received from a MySQL master to a slave, it will not be logged in the binary log of the slave server. Sometimes, you might want to enable it, for example, in order to setup a chained replication.

To do so, edit the MySQL configurations, e.g. /etc/my.cnf

..
log-slave-updates
..

Don't forget to restart MySQL to take effect.

# /sbin/service mysqld restart