usagizmo
12/20/2017 - 12:03 PM

Update wordpress on digital ocean

commands/ deploy_wp/ - deploy_wp.sh - my.conf - remote_import-sql.sh

[client]
user = [MYSQL_USER]
password = [MYSQL_PASSWORD]
#!/bin/sh
dbcid=`docker ps | awk '$2=="mysql:5.7" { print $1 }'` && docker exec -it $dbcid sh -c 'mysqldump wordpress -u wordpress -pwordpress 2> /dev/null' > ./dbdata/install_wordpress.sql
#!/bin/sh
sed -e 's/http:\/\/localhost:8000/http:\/\/[TARGET_HOST]/g' dbdata/install_wordpress.sql > dbdata/deploy.sql

scp commands/deploy_wp/remote_import-sql.sh commands/deploy_wp/my.conf dbdata/deploy.sql [HOST]:/var/www/commands/
ssh [HOST] /var/www/commands/remote_import-sql.sh

#!/bin/sh
cd /var/www/commands
# mysql -u[USER] -p[PASSWORD] [DBNAME] < deploy.sql
mysql --defaults-extra-file=my.conf [HOST] < deploy.sql
rm remote_import-sql.sh deploy.sql
#!/bin/sh
find wp-content/themes/rabi -type d -exec chmod 0755 {} \;
find wp-content/themes/rabi -type f -exec chmod 0644 {} \;
#!/bin/sh
rsync -ahvu --delete --exclude=".*" wp-content/ [HOST]:/var/www/html/wp-content/