When downgrading to MySQL 5.5 from MySQL 5.6, keep in mind the following issues relating to features found in MySQL 5.6, but not in MySQL 5.5:
The mysql.user table in MySQL 5.6 has a
password_expired column. The
mysql.user table in MySQL 5.5 does not.
This means that an account with an expired password in MySQL
5.6 will work normally in MySQL 5.5.
InnoDB search indexes (with a type of
FULLTEXT), introduced in MySQL 5.6.4, are
not compatible with earlier versions of MySQL, including
earlier releases in the 5.6 series. Drop such indexes before
performing a downgrade.
InnoDB small page sizes specified by the
innodb_page_size
configuration option, introduced in MySQL 5.6.4, are not
compatible with earlier versions of MySQL, including earlier
releases in the 5.6 series. Dump all
InnoDB tables in instances that use a
smaller InnoDB page size, drop the
tables, and re-create and reload them after the downgrade.
As of MySQL 5.6, the relay-log.info
file contains a line count and a replication delay value, so
the file format differs from that in older versions. See
Section 16.2.2.2, “Slave Status Logs”. If you downgrade a
slave server to a version older than MySQL 5.6, the older
server will not read the file correctly. To address this,
modify the file in a text editor to delete the initial line
containing the number of lines.
Beginning with MySQL 5.6.6, the MySQL Server employs Version
2 binary log events when writing the binary log. Binary logs
written using Version 2 log events cannot by read by earlier
versions of MySQL Server. To generate a binary log that is
written using Version 1 log events readable by older
servers, start the MySQL 5.6.6 or later server using
--log-bin-use-v1-row-events=1,
which forces the server to employ Version 1 events when
writing the binary log.

User Comments
Add your own comment.