从临时服务器和本地主机访问生产服务器上的 MySQL 数据以进行代码测试
如果我按照描述设置了开发方案 在这里，您建议我如何从临时服务器和本地主机访问存储在生产服务器上的数据以获取代码测试目的？
该数据由一个 MySQL 数据库组成，该数据库包含许多可通过 Sphinx 搜索进行搜索的课程信息数据表（例如课程列表）。
我不想每次将新课程添加到生产服务器时都必须在本地主机和临时服务器上重新索引和配置Sphinx以及我的数据库元素，所以欢迎任何建议。
另外，我知道存在一些类似问题，但我没有发现使用 MySQL 数据与 Sphinx 搜索和 Git 来解决问题 - 假设问题的这些元素改变了潜在的解决方案。
If I have a development scheme set up as described here, how would you suggest I access data that is stored on the production server from the staging server and from localhost for code testing purposes?
The data consists of a MySQL database that contains many tables of course information data (like a list of courses) that are searchable via Sphinx Search.
I don't want to have to reindex and configure Sphinx and my database elements on the localhost and staging server each time a new course is added to the production server, so any suggestions are welcome.
Also, I know there are a few similar questions out there, but none that I have found that address using MySQL data with Sphinx Search and Git — assuming those elements of the question change the potential solutions.
如果你对这篇内容有疑问，欢迎到本站社区发帖提问 参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱，如果其他用户或者作者回复了您的评论，将不能在第一时间通知您！
发布评论
评论（1）
那么是否正在寻找一种方法将生产数据推送到您的登台和开发环境中？
如果是这样，我不建议让您的临时环境和本地主机环境直接访问您的生产数据库...这似乎您将面临这些活动影响您的生产环境的风险。
相反，我建议进行生产备份，清除其中的所有敏感信息，然后将该数据库恢复到您的临时和开发环境中。
So are looking for a way to push down production data into your staging and development environments?
If so, I wouldn't recommend having your staging environments and localhost environments access your production database directly... that seems like you'd run the risk of those activities impacting your production environment.
Instead, I'd recommend taking a production backup, scrubbing any sensitive information out of it, and then restore that database into your staging and development environments.