mysql replication

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.
LVL 7
Robert SaylorSenior DeveloperAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

rjohnsonjrCommented:
If you are going to do it once a week.  I would say use mysqldump to dump from the old one and import into the new one.
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
Robert SaylorSenior DeveloperAuthor Commented:
I was looking for more of an mysql way. With that I would write a shell script to dump the DB, scp it, then import. This I already do was wondering of mysql replication would work and if I can set a time on it.
0
gr8gonzoConsultantCommented:
What specific versions are you using?

MySQL replication is real-time. It's not a recurring task. In most cases, you can replicate from an older master to a newer slave, but some versions may have problems. Check this article:

http://docs.oracle.com/cd/E17952_01/refman-5.5-en/replication-compatibility.html


If I were in your spot, I'd search around security blogs for problems with your current MySQL version to get some justification to move up to version 5. Sometimes the business logic of a company doesn't really see the importance of staying up to date, or the future problems with developing against older versions. But they will often pay attention to the possibilities of security breaches.
0
Robert SaylorSenior DeveloperAuthor Commented:
Old server is 4.1.22-standard-log, new server is 5.1.73 Source distribution.

Yea I did some research and looks like mysql only supports going 1 level up. I think the 5.1.73 is a little more then 1 level. I am writting a shell script to do it with mysqldump now.
0
Robert SaylorSenior DeveloperAuthor Commented:
mysqldump ultimately is the solution but the link on oracle confirmed the way I wanted to do it would not work.
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
MySQL Server

From novice to tech pro — start learning today.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.