Connect and Dump SQL from AWS RDS MySQL Server of a Vapor Project (The Easy Way Using HeidiSQL — Windows 11)

Installing HeidiSQL and Putty

Create A Laravel Vapor Jumpbox

Select a network on Laravel Vapor
Create a Vapor Jumpbox

Create a Connection Session on HeidiSQL

vapor env:pull production 
  1. Host
  2. Username: vapor
  3. Password (from the .env.production file)
  4. Databases (from the .env.production file)
New Connection in HeidiSQL

Dump SQL To The Localhost DB

  1. Right-click on the DB you want to dump.
  2. Select “Export Database to SQL”.
  3. Now you can use the setting I have in the below screenshot (Screenshot #3) or you can play around a bit to match your need. The important thing is, you must select the Output to your localhost server connection session.
Screenshot #2
Screenshot #3

--

--

--

A full-time husband and dad, who’s in his spare times like to code and make several software that make money.

Love podcasts or audiobooks? Learn on the go with our new app.

Recommended from Medium

30 Days of Actions on Google

From Dos to Developer, My Udacity Journey

Trigger AWS Lambda function using a cross account Amazon Standard SQS queue

Trigger AWS Lambda function using a cross account Amazon Standard SQS queue

How to become a Cloud cost-control guru on GCP

Python Web Scraping Part: 7 Facebook SDK

AWS — LAMP

Dockerizing an Angular app

Distributed SQL Change Management with Liquibase and YugabyteDB on GKE

Get the Medium app

A button that says 'Download on the App Store', and if clicked it will lead you to the iOS App store
A button that says 'Get it on, Google Play', and if clicked it will lead you to the Google Play store
Arung Isyadi

Arung Isyadi

A full-time husband and dad, who’s in his spare times like to code and make several software that make money.

More from Medium

Deploying Laravel 8 on Apache & Ubuntu 20.04 LTS with extra security (Modsecurity and Fail2ban)

Back to Laravel Homestead from Sail / Docker

Amazon SES — Delivering HTML Based Email Notifications

What happens when you type an URL in your browser and press Enter?