synchronizing databases across two machines

Posted on 2011-04-25
Last Modified: 2012-05-11
I have a laptop and desktop development machine, I'm trying to always be in sync with both data in database and files.

I fixed my file issue by running unison scripts which works beautifully.
My issue is my database now. Is there any graceful way to handle that or do I need to dump and reinsert every time i want to refresh updates?
I'm using mysql server.
Question by:NewtonianB
    LVL 38

    Expert Comment

    Oracle Database Lite 10g Automatic Synchronization White Paper

    Compare and synchronize Oracle databases with ease (commerical)
    LVL 38

    Accepted Solution

    Database synchronization need to be done on database level, not on filesystem level.
    You can setup replication for Master and slave (one way, from master to slave),
    Or the database dump and restore (not bad with small database ),

    Featured Post

    What Security Threats Are You Missing?

    Enhance your security with threat intelligence from the web. Get trending threat insights on hackers, exploits, and suspicious IP addresses delivered to your inbox with our free Cyber Daily.

    Join & Write a Comment

    Entity Framework is a powerful tool to help you interact with the DataBase but still doesn't help much when we have a Stored Procedure that returns more than one resultset. The solution takes some of out-of-the-box thinking; read on!
    Creating and Managing Databases with phpMyAdmin in cPanel.
    Learn how to get help with Linux/Unix bash shell commands. Use help to read help documents for built in bash shell commands.: Use man to interface with the online reference manuals for shell commands.: Use man to search man pages for unknown command…
    Learn how to navigate the file tree with the shell. Use pwd to print the current working directory: Use ls to list a directory's contents: Use cd to change to a new directory: Use wildcards instead of typing out long directory names: Use ../ to move…

    755 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

    25 Experts available now in Live!

    Get 1:1 Help Now