How to periodically roll back WordPress to a fixed point in time?

First take a SQL dump of the database in the state you want it. Then you’d write a script that accomplishes the following:

  1. Put the WP install into maintenance mode by creating a file in wp-content with the filename .maintenance and contents “Briefly unavailable for scheduled maintenance. Check back in a minute.” (or your preferred text)

  2. Drop all the tables and recreate them from your
    SQL dump.

  3. Delete /wp-content/.maintenance

Finally hook your script to a cron job in the interval you’re looking for. It’s best if this script runs completely independently of WP using a system cron job, because there are fewer moving parts and things that could go wrong than if you’re trying to do it from within a running WP environment.

Related Posts:

  1. Should I disable WP_CRON and instead trigger wp-cron.php from server every few mins?
  2. Do WordPress cron jobs slow down page loading?
  3. PHP Warning on fresh install (Connection timed out)
  4. Is there a known vulnerability for wp-cron.php?
  5. Using wp_schedule_single_event with arguments to send email
  6. wp_schedule_event is executing but the function related to the hook is not running
  7. wp_schedule_event won’t accept args
  8. add_action to wp cron?
  9. Triggering cron by calling wp-cron.php on the command line rather than with wget?
  10. wp-cron.php is triggered, but scheduled post is not published
  11. Get frequency of scheduled event
  12. Missed scheduled WordPress
  13. Do wp-cron scheduled tasks run asynchronously?
  14. Why?: hundreds of empty files named wp-cron.php?doing_wp_cron.
  15. Can’t access wp_filesystem in cron function
  16. Run a cron job (or similar) in the background of WP after post update/create
  17. what is firing cron
  18. Managing scheduled tasks
  19. custom cron interval is not working
  20. How to set up WP Cron in this scenario
  21. Where in the page load code is wp-cron triggered?
  22. Check if event was scheduled – schedule event only once
  23. wp_get_schedule and wp_next_scheduled don’t find my scheduled wp-cron job
  24. Getting Error “invalid secret string” by running wp-cron.php manually
  25. Why would wp_schedule_single_event get delayed start?
  26. Create function in functions.php with hook name to execute URL
  27. cron.php being constantly deleted [closed]
  28. Scheduling posts on wordpress adds wrong seconds as post_date
  29. WordPress Cron is scheduled but not running
  30. Execute code at the end of each quarter of year
  31. Detect if Cron is Running
  32. Run function with linux cron job in WordPress
  33. Schedule cron don’t work
  34. wp_schedule_event daily at specific time
  35. Pings disabled but WordPress is still searching for “to_ping”
  36. When to use wp_schedule_single_event for async / non-blocking processes?
  37. wp-cron.php – timeout
  38. Failed to open stream: HTTP request failed! in \wamp\www\wordpress\wp-includes\class-http.php on line 929
  39. wp-cron: freeze at “now”
  40. How could an event previously scheduled with wp_schedule_event later become unscheduled?
  41. daily wp_schedule_event hook works after reload any page
  42. update post every day
  43. Issues When Recursively Calling wp_schedule_single_event()
  44. Sync user meta fields using Wp cron job
  45. System Cron job not firing
  46. WordPress action hooks related to scheduled posts not Fired
  47. Cron job not working – Can’t see in the queue attached
  48. How to fix missing function in wp-cron?
  49. “Missed schedule” posting bug
  50. Run function after a post has finished saving – callback function perhaps?
  51. Wp Cron and WordPress Updates
  52. Code does not work in class implementation but works fine in functions.php file
  53. Use cron to create a non blocking task
  54. How to create and run cronjob in WP without using the plugin?
  55. WordPress cron hooks – same callback for completely different action?
  56. Why is apache access log not showing GET requests related to cron job?
  57. Manually running cron from the server
  58. How to solve cron problem in WordPress?
  59. Cron jobs when running multiple instances on the same DB
  60. When does wp-cron fire?
  61. WP-Cron function not firing
  62. How do i set cron job for my WordPress site?
  63. Hook/Cron Problem
  64. How can I prove if wp cron is running my task if I have DISABLE_WP_CRON set to true
  65. Delete all users when they don’t update profile_fields
  66. Email alert with wp_cron and wp_mail if new data (external API) – Pseudo code
  67. Time limit on long cron job?
  68. wp_schedule_event is registered but scheduled function isn’t running
  69. Call to undefined function wp_create_category()
  70. wp-cron.php not being triggered by wp_remote_post in spawn_cron()
  71. wp_schedule_event doesn’t work
  72. What am I doing wrong creating post draft via wp-cron? (wp_schedule_event & wp_insert_post)
  73. Most efficient way to trigger wp-cron through system cron.
  74. WP cron and update post meta
  75. How to make sure WP-CRON job loops through all posts?
  76. WordPress Multisite cron jobs using cron tab
  77. WP-Cron system doesn’t work on server
  78. Cron Job Scheduling in wordpress
  79. Schedule reminder at exact time
  80. Schedule Removal of Menu Page and Shortcode
  81. Sending emails to separate accounts using a for loop
  82. get backup file from wordpress database in x days
  83. daily job to run send email based on user data
  84. couldn’t connect to host – wp-cron.php?doing_wp_cron
  85. Run WordPress Plugin in the Specified time
  86. setting up a wp cron job
  87. Cron Lock Timeout, when to use?
  88. Cron jobs repeating themselves
  89. WordPress Cron Job Counting Up and Not Down
  90. how to crate cronjo not depending on user access
  91. Cron event running more than once if triggered from WP Crontrol
  92. Cron job for wp_cron.php running but not publishing scheduled posts
  93. How to know if WP cron is currently running my hook?
  94. Cronjob function not executed – negative seconds
  95. WP CRON Fails At 13:00 Every Day
  96. Update last created post in custom post types with wp_cron()?
  97. Custom cronjob not executing at all, but manually
  98. Not getting expected email when running cron hook
  99. ‘wp_site_health_scheduled_check’ Causes Failure Of Other Scripts
  100. How WP works with DB during cron job running?