Running a beta site (different platform than live site).
Already have export / import process via php script. Automatically gets data from one database and exports to another.
I want to automatically run this (at least daily) transfer to update the beta site with content from live site.
What's my simplest option (aside from manually running the script)?
I was considering:
Writing additional functionality into the script to track when last run or run based on a set server timestamp
Writing additional functionality to check database for new / updated data (no idea if this is possible)
?????
Also, perhaps this is better suited for a different site (not serverfault), let me know.