Life runs on code

Tag: backup

AWS S3 Sync using Crontab

AWS S3 Sync using Crontab

Install AWS cli #Download cli script curl “https://s3.amazonaws.com/aws-cli/awscli-bundle.zip” -o “awscli-bundle.zip” #unzip unzip awscli-bundle.zip #install ./awscli-bundle/install -b ~/bin/aws Create crontab script file : sync-s3.sh #/bin/bash export AWS_CONFIG_FILE=”/root/.aws/config” #change it as per user export AWS_ACCESS_KEY_ID=XXXXXXXXXXXXXXXXXHRQ export AWS_SECRET_ACCESS_KEY=XXXXXXXfHyR /usr/local/bin/aws s3 sync /var/www/testsite.com/htdocs/wp-content/uploads s3://my-imagestore/ –acl=public-read –debug Add crontab to […]

Exporting all MySQL user privileges

Exporting all MySQL user privileges

To export all MySQL user privileges run following script. Note : Replace {host_name}, {user_name} and {password} with your values. mysql -h {host_name} -u {user_name} -p{password} -Ne “select distinct concat( \”SHOW GRANTS FOR ‘\”,user,\”‘@’\”,host,\”‘;\” ) from user;” mysql | mysql -h {host_name} -u {user_name} -p{password} | sed […]