Take the 2-minute tour ×
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.

Is it possible to apply MySQL 5.1 bin log to MySQL 5.5.

I am assuming that bin log is portable between two machines (same OS, Architechture but different machines running same version of MySQL)

share|improve this question

migrated from serverfault.com Aug 29 '11 at 16:31

This question came from our site for professional system and network administrators.

    
The answer from @DTest hits the nail on the head. However, just be aware that binary logs headers have different starting points among different versions. I discussed it here (serverfault.com/questions/231369/mysql-master-binlog-corruption/…) and here (serverfault.com/questions/273407/…). For 5.5, it's 107, for 5.1 it's 106, prior to 5.1, it's 98. –  RolandoMySQLDBA Aug 29 '11 at 16:46
    
While this question does not address replication, it brings out the need to be aware of binary log header formats among MySQL versions. For that, this question gets a +1 !!! –  RolandoMySQLDBA Aug 29 '11 at 16:52

1 Answer 1

up vote 3 down vote accepted

It is possible to replicate from an older version 'master' to a new version master for the next higher major version (5.1 to 5.5 for example): http://dev.mysql.com/doc/refman/5.5/en/replication-compatibility.html

Of course bin logs are portable to the same architecture running on different machines, or replication would be almost useless (there are difficulties with running on different OSes, though).

Since your question only asked about applying a bin log to the second server, I might mention that if you don't have the 'master position' of when the second server should begin reading the binary log, you might have inconsistencies in data. Especially if it has been a long time since you've taken a full backup and no longer have the relevant log entries.

But at the heart of it, Binary Logs from an older major version to the next major version is supported.

share|improve this answer
    
Nail on the head, +1 !!! –  RolandoMySQLDBA Aug 29 '11 at 16:46

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.