markvaneijk
/ aliases.sh
Last active
July 25, 2023 11:05
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| alias valetorherd='(type herd > /dev/null && echo "herd") || (type valet > /dev/null && echo "valet")' | |
| alias aliases="nano ~/.aliases" | |
| alias autoload="composer dump" | |
| alias brewery="brew upgrade && brew cleanup -s" | |
| alias build="npx vite build" | |
| alias bump="COMPOSER_MEMORY_LIMIT=-1 composer bump" | |
| alias composer="$valetorherd php /usr/local/bin/composer" | |
| alias chrome="/Applications/Google\ Chrome.app/Contents/MacOS/Google\ Chrome" | |
| alias dev="npm run dev" |
markvaneijk
/ stream-mysql-backups-to-s3.sh
Last active
April 26, 2022 14:42
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| DAY=`date +"%d"` | |
| # sites | |
| for DIR in /var/www/*; do SITE=$(basename "$DIR"); [[ $SITE = "default" ]] && continue; tar -cf - $DIR | gzip -9 | pv -L 1m -q | s3cmd --acl-private put - s3://%S3_BUCKET%/rocketeers/backups/%SERVER%/$SITE/files/$DAY.tar.gz; done | |
| # databases | |
| echo "SHOW DATABASES;" | mysql --user=%MYSQL_USER% --password=%MYSQL_PASSWORD% | grep -v -E "^(Database|mysql|sys|information_schema|performance_schema)$" | while read DATABASE; do mysqldump --user=%MYSQL_USER% --password=%MYSQL_PASSWORD% --add-drop-table --column-statistics=0 --extended-insert --no-tablespaces --single-transaction --skip-comments $DATABASE | gzip -9 | pv -L 1m -q | s3cmd --acl-private put - s3://%S3_BUCKET%/rocketeers/backups/%SERVER%/$DATABASE/databases/$DAY.sql.gz; done |
markvaneijk
/ html-template.html
Last active
April 26, 2022 14:42
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| <!DOCTYPE html> | |
| <html> | |
| <head> | |
| <title></title> | |
| <meta charset="utf-8"> | |
| <meta name="description" content=""> | |
| </head> | |
| <body> | |
markvaneijk
/ sftp.sh
Last active
April 26, 2022 14:42
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| # sshd config | |
| nano /etc/ssh/sshd_config | |
| Match User rocketeer | |
| ChrootDirectory / | |
| Subsystem sftp internal-sftp | |
| # permissions |