建议同步本地和实时Wordpress数据库的最佳工作流程是什么? [英] What is the recommended best workflow syncing local and live wordpress database?
问题描述
从我的phpMyAdmin导出和导入数据库(实时导出到本地-反之亦然)正成为一项繁琐的任务，并且容易出现不一致的情况.有时候，我导入了一个错误的数据库文件，该文件位于我的下载文件夹中，并用错误的内容覆盖了我的数据库，幸运的是我仍然有备份.
Exporting and importing database from my phpMyAdmin (live to local - and vice versa) is becoming a tedious task and prone to inconsistency. There are times the I imported a wrong database file that was on my downloads folder, overwriting my database with a wrong recored, lucky I still have a backup.
是否有更好的工作流程，如何将数据库从本地服务器同步到实时服务器?我需要同步我的实时到本地和本地实时，因为更改是在两侧进行的，本地更改是为在网站上工作的开发人员(也就是我)，而实时是为发布者和管理员提供的谁在发布内容或使用实时网站执行一些管理任务.
Is there a better workflow how to sync database from your local to live server? I need to sync my live-to-local and local-to-live because the changes are happening in both sides, the local changes is for the developer working on the site (which is me) and the live is for the publisher and administrator who's publishing content or doing some administration tasks with the live site.
我希望那里有一个具有版本控制选项的解决方案，这样，如果我搞砸了，我仍然可以回到更早的阶段.
I wish there solution like it has a version control option, so, that if I messed up I can still go back to an earlier stage.
如果它是一个软件解决方案，那么我正在OS X(10.8.3)上运行.我使用wordpress，coda和Mamp.
Incase it's a software solution, I'm running on OS X (10.8.3). I use wordpress, coda and Mamp.
推荐答案
我们开发了wordpress网站，并且有许多开发人员在多种环境中工作.我们发现了这个插件，使我们的生活变得非常简单. (我们没有做到这一点，也没有得到他们的报酬来推广它)
We develop wordpress sites and have many developers working in multiple environments. We've found this plugin that makes our life extremely simple. (We didn't make it, and we aren't paid by them to promote it)
http://deliciousbrains.com/wp-migrate-db-pro/
我们发现，只需支付少量的费用(对于我们来说是99美元)，它就节省了我们很多时间，可以在我们可以实际赚取的可计费时间内弥补.
We've found that for the small amount paid ($99 for us) it has saved us TONS of time, making up for it in billable hours we can actually earn on.
这篇关于建议同步本地和实时Wordpress数据库的最佳工作流程是什么?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！
