SSH into your machine
curl -o setup-vps.sh https://raw.githubusercontent.com/lindesvard/ubuntu-helper-script/master/setup-vps.sh && sudo chmod +x setup-vps.sh && ./setup-vps.sh
Then run: ./setup-vps.sh
curl -o install-nvm.sh https://raw.githubusercontent.com/lindesvard/ubuntu-helper-script/master/install-nvm.sh && sudo chmod +x install-nvm.sh && ./install-nvm.sh
Before you can run this command you need to change $MYSQL_USER and $MYSQL_PASSWORD in create-db.sh.
This command will create a database and a user. Replace {{db_name}}, {{db_user}} and {{db_password}} with your config.
sh create-db.sh {{db_name}} {{db_user}} {{db_password}}
pg_dump -U difstart_user difstart_db --password >> db_dump.sql
pg_dump --data-only --inserts --column-inserts -U difstart_user difstart_db --password >> db_dump.sql
pg_dump --data-only --inserts --column-inserts -U difstart_user difstart_db --password -t '"Sources"' -t '"Articles"' -t '"ArticleTags"' -t '"KeywordTags"' >> rest.sql
pg_dump --data-only -U difstart_user difstart_db --password >> db_dump_data.sql
psql -U difstart_user difstart_cms --password < db_dump.sql
pg_restore -U difstart_user difstart_cms --password -F t -f
rsync -chavzP -e "ssh -p 22123" [email protected]:/var/lib/postgresql/db_dump.sql ./db_dump.sql
rsync -chavzP -e "ssh -p 22321" ./db_dump.sql [email protected]:/home/web/db_dump.sql
systemctl unmask postgresql
systemctl restart postgresql