- Removed the MySQL-specific
--set-gtid-purged=OFF
to thecommon_mysql.sh
from the mysqldump command options
- Added
--set-gtid-purged=OFF
to thecommon_mysql.sh
to avoid permissions issues with some database dumps - Added support for a
LOCAL_AWS_PROFILE
variable, which lets you specify which AWS named profile to connect to S3 with. - Add in-folder
.gitignore
to ensure that.env.sh
is ignored
- Fix
TMP_LOG_PATH
for local db backups
- Added
--no-tablespaces
to the mysqldump command options to work around changes in MySQL
- Don’t dump permission/ownership info for postgres
- Add
templatecachequeries
to the db tables excluded from database dumps
- Refactor out to functions thanks to
preposthuman
- Code cleanup and refactoring thanks to
preposthuman
- Fixed an issue with the backup path for the
backup_dir.sh
script (again) - Made
web/cpresources
a defaultLOCAL_WRITEABLE_DIRS
in thecraft3-example.env.sh
- Added
restore_assets.sh
restores the assets from the backup that has been created withbackup_assets.sh
. - Added
restore_dirs.sh
restores the dirs from the backup that has been created withbackup_dirs.sh
- Fixed an issue with the backup path for the
backup_dir.sh
script
- Added separate example starter
*-example.env.sh
for Craft 2.x & Craft 3.x - Added composer support
- Updated README.md
- Fixed an issue where remote db pulls wouldn't exclude db tables that should have been ignored (such as the templatecaches table)
- Added support for pulling db dumps directly from hosted MySQL/Postgres servers (needed for Heroku and other environments)
- Output from
clear_caches.sh
is suppressed for the table dropping (to prevent spurious "table doesn't exist" errors) - Support for proper Postgres cache table purging
- Fixed the
clear_caches.sh
script formysql
- Added
postgres
database support for Craft 3
- Updated
README.md
- Added support for backups to an Amazon S3 bucket sub-folder
- Added section links to the README.md
- Added support for clearing the FastCGI Cache in
clear_caches.sh
viaLOCAL_FASTCGI_CACHE_DIR
- The
pull_assets.sh
script now deletes local assets that have been removed from the remote - Added support for clearing the Redis cache in
clear_caches.sh
viaLOCAL_REDIS_DB_ID
- Added the
backup_files.sh
script to backup arbitrary directories of files - Added
rsync -F
to allow for excluding files/directories via.rsync-filter
files - Fixed an unparsed error message if one of the include scripts is missing
- Revised
README.md
- Changed
zcat
togunzip -c
for MaxOS X compatibility
- Added the
sync_backups_to_s3.sh
script to sync backups to an Amazon S3 bucket - Pull all the backups on
pull_backups.sh
- Added the
restore_db.sh
script to make restoring local databases easier
- Revised
README.md
to documentrestore_db.sh
- Added the ability to run the scripts from anywhere (no need to
cd
to the directory) - Added
backup_db.sh
for doing local, rotating database backups - Added local asset backup via
backup_assets.sh
- Added the ability to pull backups down from the remote server via
pull_backups.sh
- Added pulling of the Craft
userphotos
&rebrand
directories viapull_assets.sh
- Added support for
.gz
compressing the database before transfering it, to speed things up - Added support for restoring directly from a
.gz
compressed database dump - Added additional arguments to the
mysqldump
- Added
common/defaults.sh
to set reasonable defaults for many settings - Added the ability to change the
craft
folder location - Added an
example.gitignore
that you can use in your Craft CMS projects - Added
com.example.launch_daemon.plist
as a Mac Launch Daemon example
- Revised
README.md
to document the changes/new features - Code cleanup & refactoring
- Added support for
login-path
to store your mysql db credentials in an encrypted file, and thus avoidmysql: [Warning] Using a password on the command line interface can be insecure.
warnings - Added
LOCAL_DB_HOST
andLOCAL_DB_PORT
to the.env.sh
- Added
REMOTE_MYSQL_CMD
andREMOTE_MYSQLDUMP_CMD
to the.env.sh
- Added the
crontab-helper
file you can add to yourcrontab
as a crib sheet - Added the
cache
table as one to delete/ignore
- Made the scripts more tolerant of missing settings (perhaps due to old
.env.sh
files) - Refactored common code out to
common/common_db.sh
andcommon/common_env.sh
- Updated the
README.md
with information aboutfileMode
- Updated the
README.md
with information aboutlogin-path
- Exclude cache/temporary tables from db dumps (both local and remote)
- Move to a global setting for
GLOBAL_DB_TABLE_PREFIX
- Harmonized the comments
- Harmonized the {} usage for quoted or combined variables
- Broke out the changelog to CHANGELOG.md
- Added mysql host and port constants
- Update pull_db.sh to use --flags
- Initial release
Brought to you by nystudio107