Skip to content

Instantly share code, notes, and snippets.

@kojiisd

kojiisd/file0.sql

Created January 1, 2019 01:53
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save kojiisd/575c67a49c81cc76b14b2e97200ab7ec to your computer and use it in GitHub Desktop.
Save kojiisd/575c67a49c81cc76b14b2e97200ab7ec to your computer and use it in GitHub Desktop.
Download ZIP
低コストかつ簡単な方法でWebページを作成・更新をできるようにしてみた ref: https://qiita.com/kojiisd/items/58ebc5cd848484b58677
Raw
file0.sql
update wp_posts set guid=REPLACE(guid, 'http://＜旧IPアドレス＞/', 'http://＜新IPアドレス＞/') where post_type='page';
update wp_options set option_value=REPLACE(option_value, 'http://＜旧IPアドレス＞', 'http://＜新IPアドレス＞') where option_value like ('%＜旧IPアドレス＞%');
Raw
file1.sh
$ aws ec2 start-instances --instance-ids <InstanceID>
$ aws ec2 stop-instances --instance-ids <InstanceID>
Raw
file2.sh
$ aws ec2 describe-instances --instance-ids <InstanceID>| jq '.Reservations[].Instances[].PublicIpAddress'
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment