Problem: Create a cron job to export posts to a WordPress XML file on server
I need a way to automatically export all WordPress posts from a specific date and have it output the file on the server that can be downloaded daily.
backup
Backup the Database and Restore from the Backup?
I am using WordPress 3 and would like to backup the database to my computer (a Mac). My webhost is using PHP safe mode, so that sometimes limits what plugins I can use. What is a good way to do a database backup? Is it possible to be automated? Are incremental backups recommended/easy? Obviously I then need to test restoring form a backup.