Happenn
  • Introduction
  • System Architect
  • For Dev
    • AWS
      • Domain & CNAME
      • Rescale Instance
      • Request AWS Certificate
      • Generate Certificate with Certbot
      • S3
      • SSH & FTP
      • Auto Scaling
      • RDS MySQL
    • Digital Ocean
      • Virtual Host & Certificate
      • SSH & FTP
    • Server
      • Git
      • Setup the Server
    • Code
      • Laravel/Lumen
      • Vue.js
      • Webpack
      • JavaScript Library
        • Lodash
        • axios
        • Moment.js
      • Code Style Guide
      • Useful Tools
    • HAM Admin
      • Install locally
      • Deploy
    • Happenn API
      • Install locally
      • Install DB locally
      • Make DB changes
    • Happenn IO
      • Install locally
    • Happenn Virtual
      • Install locally
      • Folders and file structure
      • Deploy code
        • Happenn AWS
        • Delegia AWS
    • Happenn Event app
      • Deploy
      • Install locally
Powered by GitBook
On this page
  • Tools/Items needed:
  • Connect Production database
  • Backup/ Download database
  • Restore database locally
  1. For Dev
  2. Happenn API

Install DB locally

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

PreviousInstall locallyNextMake DB changes

Last updated 2 years ago

Tools/Items needed:

  • dbForge Studio Express Or equivalent software depending on developer OS.

  • mySQL server (Xampp, Mampp or equivalent)

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.

https://www.devart.com/login.html?requestedUrl=/dbforge/sql/studio/download.html%3Ffd=dbforgesqlfree.exe
https://www.apachefriends.org/