How to keep mySQL content in sync on dev and live servers?
I’ve been building my first WP site on my live server which is fine for now because it’s not public yet, so if I break something it’s OK since nobody’s looking at the site (and I have it password-protected until launch). But once it’s launched and no longer protected, and people are visiting it, I’ll want to be able to make edits to my child theme and to content locally on my office computer and test changes there instead, before uploading them to my host server. So I expect I’ll install MAMP and use FTP-based sync for my child theme’s files, as I have done before on a traditional static site. But since WP uses a mySQL database for the content, I will also need to keep my local database and the hosted database in sync and FTP would not work well for that unless I know exactly which files contain mySQL’s data and I lock visitors out from posting comments while I’m making updates locally, right? Is there a simple utility for keeping the databases in sync? If not, how have other people addressed this issue?
- The topic ‘How to keep mySQL content in sync on dev and live servers?’ is closed to new replies.