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.