Ghost Update for MySQL or GUM for short is a script I wrote inspired by allaboutghost.com. I noticed there was a gap in that there were no updater scripts for those that use the MySQL database. Here is a script I cobbled together from a number of different sources. I plan to improve this so its more useable going forward.
#!/bin/bash DATE=$(date +%d-%m-%Y_%H_%M) bkdir="/var/www/ghost" bkdir1="/var/www/ghost/mysql_exports" if [ -f config.js ] then cp -R /var/www/ghost/app/ /var/www/ghost/gupdgrade-bk-$DATE echo `whoami` # Make temporary directory and download latest Ghost. mkdir temp cd temp wget https://ghost.org/zip/ghost-latest.zip unzip *.zip cd .. # Make database backups. mysqldump -u<username> -p<password> --databases ghost --lock-tables=false --no-create-db > $bkdir1/ghostdb-$DATE.sql # Copy the new files over. yes | cp -R temp/*.md yes | cp -R temp/*.js yes | cp -R temp/*.json . rm -R core yes | cp -R temp/core . yes | cp -R temp/content/themes/casper content/themes npm install --production # Delete temp folder. rm -R temp echo "You can now start Ghost with npm, forever or whatever else you use." else echo "Please cd to your Ghost directory." fi