One thing that kept me from getting my blog back up for a while was the lack of a consistent backup strategy for the WordPress content and the website as a whole. Website backup should be easy, with these commands and the following script, it’s very easy.
This is just a starting point though, I have some ideas about backup that I plan to explore in future experiments.
Quick backup command lines:
12 ssh user@host mysqldump --all-databases -p --result-file=db-backup-`date +%Y%m%d`.sqlrsync -av --delete user@host:/remoteSource localDestination