RDS Database Backup: Difference between revisions
Jump to navigation
Jump to search
No edit summary |
No edit summary |
||
| Line 3: | Line 3: | ||
The address for the host can be found in the AWS RDS console. | The address for the host can be found in the AWS RDS console. | ||
In ''DataGrip'': | In '''DataGrip''': | ||
* Right click on the database. | * Right click on the database. | ||
Revision as of 04:20, 23 November 2021
Connect to the database in a client app such as DataGrip or dbForge Studio or MySQLWorkbench.
The address for the host can be found in the AWS RDS console.
In DataGrip:
- Right click on the database.
- SQL Scripts > SQL Generator
- This will display SQL that defines the objects and data in the database.
- There are 3 icons on the right side of the SQL Generator pane. Click the disk icon to save the SQL to a file on disk.
In MySQLWorkbench: App main menu > Server > Data Export