implement-devops/Migrate a MySQL Database to Google Cloud SQL at master · Sandeepdhungana/implement-devops · GitHub

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
#WATCH FULL VIDEO ON : https://www.youtube.com/watch?v=UMu6HChisU0


export ZONE=us-central1-a


gcloud sql instances create wordpress --tier=db-n1-standard-1 --activation-policy=ALWAYS --gce-zone $ZONE


gcloud sql users set-password --host % root --instance wordpress --password Password1*


export ADDRESS=<external IP of blog vm/32>


gcloud sql instances patch wordpress --authorized-networks $ADDRESS --quiet


gcloud compute ssh blog --zone=us-central1-a


MYSQLIP=$(gcloud sql instances describe wordpress --format="value(ipAddresses.ipAddress)")


mysql --host=[INSTANCE_IP_ADDR] \
    --user=root --password


CREATE DATABASE wordpress;
CREATE USER 'blogadmin'@'%' IDENTIFIED BY 'Password1*';
GRANT ALL PRIVILEGES ON wordpress.* TO 'blogadmin'@'%';
FLUSH PRIVILEGES;


sudo mysqldump -u root -pPassword1* wordpress > wordpress_backup.sql


mysql --host=$MYSQLIP --user=root -pPassword1* --verbose wordpress < wordpress_backup.sql


sudo service apache2 restart


cd /var/www/html/wordpress


sudo nano wp-config.php