Wrote a #Bash script to use WP-CLI to dump the database, then #Rclone to sync the files to Dropbox.
It pings HealthChecks.io to monitor progress & success/fail.
That was finally working well. 👍
Then calling it from a #cronjob revealed the need to use full paths to commands like #PHP & WP-CLI. Took a bit to find (force) the logging of the cron to see what was wrong.
Still unclear why some commands (curl, etc) work fine.
@syntaxseed There was a mysql cloning script I used to run that auto-rotated backups, rolled them up when the month had passed. I can't remember what it used or was called, but it was designed to backup mysql, not wordpress. The benefits of such an approach are that the backup is pure SQL, and years of others learnings can help.
The nice thing, is using the sync mode of #Rclone means the initial upload took ages but successive backups only do the changed files so it's pretty quick.
Also had to debug ways to ease back the rate limiting from #Dropbox, luckily there was some good info about this in the Rclone discussion forums.
It cracks me up that Rclone refuses to sync Thumbs.db files. It spits an error when it encounters them. Even file copy utilities hate these! 🤣 This was an effective way to find and purge these.
Add comment