RDS Database Backup: Difference between revisions

Revision as of 15:40, 20 August 2022

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
In the SQL Generator pane, click the gear icon on the left.
- Generate: Creation script completely
- Set other options as needed.
After selecting the Generate option, SQL will be displayed in the left pane that fulfills that option.
There are 3 icons on the right side of the SQL pane. Click the disk icon to save the SQL to a file on disk.

In MySQLWorkbench: App main menu > Server > Data Export

@@ Line 7: / Line 7: @@
 * Right click on the database.
 * '''SQL Scripts''' > '''SQL Generator'''
-* This will display SQL that defines the objects and data in the database.
+* In the '''SQL Generator''' pane, click the gear icon on the left.
-* 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.
+** '''Generate:''' ''Creation script completely''
+** Set other options as needed.
+* After selecting the '''Generate''' option, SQL will be displayed in the left pane that fulfills that option.
+* There are 3 icons on the right side of the SQL pane. Click the disk icon to save the SQL to a file on disk.
 In '''MySQLWorkbench''': App main menu > '''Server''' > '''Data Export'''
 [[Category:RDS]][[Category:AWS]][[Category:Web Development]]