Documentation Home
MySQL Replication
Related Documentation Download this Excerpt
PDF (US Ltr) - 0.9Mb
PDF (A4) - 0.9Mb
HTML Download (TGZ) - 278.3Kb
HTML Download (Zip) - 293.1Kb

MySQL Replication  /  ...  /  Replication and TIMESTAMP

4.1.32 Replication and TIMESTAMP

Older versions of MySQL (prior to 4.1) differed significantly in several ways in their handling of the TIMESTAMP data type from what is supported in MySQL versions 5.5 and newer; these include syntax extensions which are deprecated in MySQL 5.1, and that no longer supported in MySQL 5.5. This can cause problems (including replication failures) when replicating between MySQL Server versions, if you are using columns that are defined using the old TIMESTAMP(N) syntax. See Changes in MySQL 5.5, for more information about the differences, how they can impact MySQL replication, and what you can do if you encounter such problems.