search

voluntaryist / site

voluntaryist.com website
10 stars 3 forks source link

Shell script to backup the WP DB and commit it to git. #7

Open dscotese opened 9 years ago

dscotese commented 9 years ago

Putting this script on a cron job, once it is ready, will provide good support for what I imagine will be a long process of moving the existing content into WordPress.

dscotese commented 9 years ago

This script needs to skip the table containing user accounts (so the passwords can't be brute-forced by someone who just gets the backup database). mysqldump has a switch, --ignore-table. StackExchange shows how to use it. The instructions for setting up the website on your dev machine need to be updated to tell the contributor to set up wordpress with users before restoring the backed up database. That way, each dev will have their own set of private passwords. I'm working on it.