• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 320
  • Last Modified:

MySQL Database Mirroring

I have several MySQL databases residing on a webserver that I would like to mirror/copy to duplicate databases on our local internal server. We already have a secure tunnel and access to the server but I really need to know how to automate the copying/mirroring of the data.
0
whittinga2
Asked:
whittinga2
2 Solutions
 
Didier VallySystems Engineer and Finance AnalystCommented:
0
 
whittinga2IT DirectorAuthor Commented:
0
 
woepwobinCommented:
Set up mysql database replication: http://dev.mysql.com/doc/refman/5.0/en/replication.html.

Follow the steps on http://dev.mysql.com/doc/refman/5.0/en/replication-howto.html, 5.1.1.1 through 5.1.1.5, and then 5.1.1.10.
0
Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say thank you for being a part of the community.

 
mohansahuCommented:
Hi,

Plz check the check the below link for to Set Up Database Replication In MySQL  in detail.

http://www.howtoforge.com/mysql_database_replication

MS
0
 
whittinga2IT DirectorAuthor Commented:
Thank you to you both. I have read both of these documents previously and I was hoping for something a little easier. Appreciate your help.
0
 
woepwobinCommented:
If you need any help with the individual steps just ask.
0
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.

Join & Write a Comment

Featured Post

Upgrade your Question Security!

Your question, your audience. Choose who sees your identity—and your question—with question security.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now