We launched new forums in March 2019—join us there. In a hurry for help with your website? Get Help Now!
    • 6057
    • 26 Posts
    Hi,

    Following on from my previous post, I have successfully migrated my prototype site from my laptop to a server on the network (not a live internet site yet).

    The website on the server will give people access to a snapshot of the prototype so that they can give some feedback etc. I had planned to continue working on the prototype on my laptop (since I can do that when I’m not in the office) and then every so often do new snapshots and synchronize them up to the server.

    I tried a DB export and import between laptop and server. The import failed, saying that the modx_ database already exists. Thinking about it, this makes sense - the export must be a script to create the whole database from scratch.

    The question is, how do I export just the changes since last snapshot from my laptop and import them onto the server?

    As always - hope this isn’t a silly question - this is all new to me (and I haven’t got the hang of finding things in the forums yet wink )

    Cheers,

    Colin
      • 3960
      • 1 Posts
      I do this on a regular basis using SQLyog Enterprise. You can even set up scripts to sync database changes automatically. SQLyog also lets you sync schema changes between databases.