Solved

Synchronise 2 databases on remote computers not a network

Posted on 2008-10-22
6
223 Views
Last Modified: 2013-11-05
Hello

I have 2 computers that I work on. I need to keep these computers in synch. I use mysql database version 5.0. What is the easiest way to keep these 2 databases in sync. what files would i need to copy from one machine to another? Is there something else i could do?

thanks
0
Comment
Question by:andieje
  • 3
6 Comments
 
LVL 7

Expert Comment

by:mattaob
Comment Utility
are you planning on writing to both servers?

If you are you could set up master - master replication - that way you wouldn't have to worry about copying files anywhere mysql would handle it all.

http://www.howtoforge.com/mysql_master_master_replication
0
 
LVL 7

Expert Comment

by:mattaob
Comment Utility
alternatively if you're only writing to one of them you could use master - slave replication

http://members.cox.net/midian/howto/mysqlReplication.htm
0
 

Author Comment

by:andieje
Comment Utility
hi, i dont thinki i worded my question very well. Neither of the machines are servers, they are both simply development machines that i work on. I work on one machine in the day and one machine at night. Any changes i make to one database in the day i would like to propagate to the machine i use in the evening. The computers are not connected via a network in any way so i dont think i can use replication as shown in the links upi recommend.
thanks
0
 
LVL 7

Accepted Solution

by:
mattaob earned 500 total points
Comment Utility
in that case use mysqldump to dump the database and then restore it
0

Featured Post

Comprehensive Backup Solutions for Microsoft

Acronis protects the complete Microsoft technology stack: Windows Server, Windows PC, laptop and Surface data; Microsoft business applications; Microsoft Hyper-V; Azure VMs; Microsoft Windows Server 2016; Microsoft Exchange 2016 and SQL Server 2016.

Join & Write a Comment

Suggested Solutions

Does the idea of dealing with bits scare or confuse you? Does it seem like a waste of time in an age where we all have terabytes of storage? If so, you're missing out on one of the core tools in every professional programmer's toolbox. Learn how to …
Load balancing is the method of dividing the total amount of work performed by one computer between two or more computers. Its aim is to get more work done in the same amount of time, ensuring that all the users get served faster.
This video discusses moving either the default database or any database to a new volume.
You have products, that come in variants and want to set different prices for them? Watch this micro tutorial that describes how to configure prices for Magento super attributes. Assigning simple products to configurable: We assigned simple products…

771 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

11 Experts available now in Live!

Get 1:1 Help Now