Hi, it's been about 5+ years since I setup a master/slave mysql setup and have a few question.
1. The primary mysql server is running version 4. This is our production server. It's 4 because of old PHP code. Work won't let me spend the time to convert so it's 4 until their is a major problem.
2. I setup a new mysql server to run some off production reports, etc. However, I have to manually dump the data from the mysql 4 server then import into the mysql 5 server.
What is the best way to replicate mysql 4 database to a mysql 5 database. I want to automate this task maybe once per week.