RDS Database Backup

From Littledamien Wiki
Revision as of 15:40, 20 August 2022 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
  • 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

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