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 like to code for some money. Currently being entrusted as an Engineering Manager at an awesome team.

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

Recommended from Medium

Sinatra Project

Error Proof Your PHP with Type Hints and Return Types

Wix Engineering Podcast, E02: Growing Pains

Ah yes Dells Support Assist backup.

Week13 — News, Updates & Reminders — AWS | HashiCorp | Istio | Kubernetes | Linux

Tech News, Updates and Press Conference

Running scheduled jobs / tasks using GitLab CI/CD

Finally Day off

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 like to code for some money. Currently being entrusted as an Engineering Manager at an awesome team.

More from Medium

What the heck is hack?

Laravel asset compilation for Laravel 9 + Laravel Mix 6 + Font Awesome 6

Finding Function — PHP

How is working laravel services?