On RTA Server
***************************************
--------------------------------------
Export Data
--------------------------------------

ssh webr@108.61.149.14
PGPASSWORD="pland" pg_dump --clean  -U  pland pland | gzip > /home/webr/db_backup/database_backup/pland_prod-$(date +"%d-%m-%Y").psql.gz



On RTA2 Server
***************************************
--------------------------------------
Take backup before importing new data
--------------------------------------
cd /home/hradmin/rta2.0/

PGPASSWORD=pland pg_dump -d prod_rta -U pland  --no-owner  -f /home/hradmin/rta2.0/local/local_psql_pland_prod-$(date +"%d-%m-%Y").psql
gzip /home/hradmin/rta2.0/local/local_psql_pland_prod-$(date +"%d-%m-%Y").psql
mysqldump -uroot -p dev_rta | gzip > /home/hradmin/rta2.0/local/local_mysql_rta-$(date +"%d-%m-%Y").sql.gz

--------------------------------------
Clean up
--------------------------------------

mysql -uroot -p dev_rta < /var/www/html/dev_rta/sql/clean-up.sql


--------------------------------------
Import Data
--------------------------------------

1. Unzip database
gunzip /home/hradmin/rta2.0/pland_prod$(date +"%d-%m-%Y").psql.gz


2.

Not required --- sudo --login --user=postgres psql -d prod_rta

PGPASSWORD=pland psql -d prod_rta -U pland -f /var/www/html/dev_rta/sql/postgres_db_clean.sql
PGPASSWORD=pland psql -d prod_rta -U pland -f /home/hradmin/rta2.0/pland_prod$(date +"%d-%m-%Y").psql
PGPASSWORD=pland psql -d prod_rta -U pland -f /var/www/html/dev_rta/sql/psql_migration_prep.sql

3.
Open rta2.0 app in web browser and run the migration job
https://rta2.puntlandgov.org/en/login
https://rta2.puntlandgov.org/en/migrate?all