RDS Database Backup

From Littledamien Wiki
Revision as of 04:20, 23 November 2021 by Video8 (talk | contribs)
Jump to navigation Jump to search

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

Retrieved from "https://wiki.dbarchowsky.com/index.php?title=RDS_Database_Backup&oldid=3184"