• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 314
  • 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
 
whittinga2Author 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 learning courses: Active Directory Deep Dive

Get a firm grasp on your IT environment when you learn Active Directory best practices with Veeam! Watch all, or choose any amount, of this three-part webinar series to improve your skills. From the basics to virtualization and backup, we got you covered.

 
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
 
whittinga2Author 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

Featured Post

Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

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