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.
Last updated