search

jasperf / trellis-sync

Trellis Database and Uploads Folder Synchronisation scripts and example WP CLI Aliases
MIT License
28 stars 7 forks source link

Backup? #2

Open strarsis opened 7 years ago

strarsis commented 7 years ago

This script works really nice for transferring data between WordPress installations. Is there also an example for using this script for backing up to tar/gzip, ideally incrementally (important for the uploads files), with date/time stamps? I plan to run the script in regular intervals for automated site backups (from production site which holds the authoritative data).

jasperf commented 7 years ago

Yeah that would be good. Rsynch could probably be used for that. A lot on my plate though so not sure when I will have time to add the necessary commands to work on that..

strarsis commented 7 years ago

@jasperf: This tool uses mysql dump + rsync for dumping the mysql database contents and transferring it together with the uploaded files. If the script could be modified to just pull these files into a directory or into a tar.gzip, or even to leverage the rsync incremental backup feature.

jasperf commented 7 years ago

Rsync should perform incremental backups by default. If you want to automate these backups you can read about that at https://www.maketecheasier.com/make-incremental-backups-with-rsync/ . And it uses compression using the -z in rsynch -az: -z, --compress compress file data during the transfer for transfer. Perhaps we could work on a piped command to gzip on the destination machine though.

strarsis commented 7 years ago

@jasperf: Any news? This would be a great addition, also for automated remote backups with versioning. 🦄

jasperf commented 7 years ago

Been really busy working on Stedding - Ansible playbooks for Laravel LEMP Stack. If you have a suggested implementation @strarsis please do a PR. Thanks!