Install DB locally

Remember: NEVER change tables/ columns directly in the DB. Look at Make DB changes (We use migrations)

Tools/Items needed:

• dbForge Studio Express https://www.devart.com/login.html?requestedUrl=/dbforge/sql/studio/download.html%3Ffd=dbforgesqlfree.exe Or equivalent software depending on developer OS.

• mySQL server (Xampp, Mampp or equivalent) https://www.apachefriends.org/

Connect using dbForge Studio Express

Start by downloading dbForge Studio Express

Connect Production database

After installation you can start to connect to AWS RDS

in the host column write: happenn-api-instance-1.ctsu9t8qho1q.ap-southeast-1.rds.amazonaws.com

Username, Password: Ask a developer for credentials.

Backup/ Download database

Right click the successfully connected DB happenn-api and choose Backup and Restore Database

Restore database locally

You can either choose the sql file that has followed the git clone located in \import database\happenn_api.sql or use your downloaded production sql file.

Start your Xampp SQL server and go back to dbForge & connect to localhost, create a new database named: happenn-api (Collation: UTF-8)

Right click the newly created database and choose Backup and restore Database. Choose your downloaded sql file from production and restore.