I have a few schemas, Which are included in mysql 4 instance, And i want to move them to other mysql instance which running under a newer version - mysql 5.6. This instance is already including some schemas. I want to move these schemas from the old version to the new version, And so to get rid of the old mysql instance.
What is the best practice to do so? Do i need to upgrade each version (4-->5.0, 5.0-->5.1, etc), And only after the schemas will be updated to version 5.6 i will be able to move them to the new instance?
I don't have any experience with mysql upgrading, So any tip would be great.