RDS Database Backup: Difference between revisions
Jump to navigation
Jump to search
No edit summary |
No edit summary |
||
| Line 2: | Line 2: | ||
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'': | |||
* 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''' | In '''MySQLWorkbench''': App main menu > '''Server''' > '''Data Export''' | ||
[[Category:RDS]][[Category:AWS]][[Category:Web Development]] | [[Category:RDS]][[Category:AWS]][[Category:Web Development]] | ||
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