## ADD HELM REPO

helm repo add bitnami https://charts.bitnami.com/bitnami

helm show values bitnami/wordpress --version=15.2.5 > values.15.2.5.yaml


## BACKUP DATABASE

mysqldump -h 127.0.100.1 -p -uroot wp_sapian_cloud > /home/cristian/Documentos/mysql-cur-backups/www/mariadb.default.svc.cluster.local-wp_sapian_cloud-2023-03-23.sql

mysql -p -uwp_sapian_cloud -h 127.0.200.1 --one-database wp_sapian_cloud < /home/cristian/Documentos/DOCUMENTOS_IMPORTANTES/PVC/wordpress/mariadb.default.svc.cluster.local-wp_sapian_cloud-2022-09-27.sql

mysql -p -uwp_sapian_cloud -h 127.0.200.1 --one-database wp_sapian_cloud < /home/cristian/Documentos/mysql-cur-backups/www/mariadb.default.svc.cluster.local-www-2023-01-25.sql

## DATABASE 

kubectl exec --stdin --tty mariadb-primary-0 -- /bin/bash

CREATE DATABASE wp_sapian_cloud;

USE wp_sapian_cloud;

GRANT ALL PRIVILEGES ON *.* TO 'wp_sapian_cloud'@'%' IDENTIFIED BY 'WeiPh9muthiM4jaiCh0ieth5upaiShif';

GRANT ALL PRIVILEGES ON wp_sapian_cloud TO 'wp_sapian_cloud'@'%';

## KRSYNC

krsync -avz sapiantools-647fb8495c-fnd22:/wp-cloud-wordpress-fs/ /home/cristian/Documentos/DOCUMENTOS_IMPORTANTES/PVC/wordpress/2022-28-09/

krsync -avz --progress --stats /home/cristian/Documentos/pvc-cur/wordpress/2023-02-07/ sapiantools-57fdbd-hnsz7:/wordpress-www-01-med-rwo/

### INSTALL HELM

helm install www-dialbox-cloud bitnami/wordpress -n www --values values.yaml

helm install wordpress-test bitnami/wordpress -n www --version=12.3.3 --values values.12.3.3.yaml

## HELM UPGRADE

helm upgrade www-dialbox-cloud bitnami/wordpress  --version=15.2.5 -n www --values values.yaml

# Wordpress Customization

## Google Maps
Fix, add or mod the keys url or ips here
https://console.cloud.google.com/apis/credentials?project=sapiancomco-1531131691088

`wp-content/plugins/component-shortcodes/shortcodes/class-google-map.php`

## Flaoating Button

https://git.sapian.com.co/Sapian/www.sapian.com.co/src/branch/master/wordpress/plugins/floating-button