RDS Database Backup

From Littledamien Wiki
Revision as of 21:03, 15 March 2023 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.

DataGrip

Export database objects

  • 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.

Export data

  • Right click on the database.
  • Import/Export > Export with 'mysqldump'
    • Out path: [path to location of exported data]
    • Databases: [Defaults to the database that was clicked]
    • Tables: [Leave blank for all tables in database]
    • Select from options with checkboxes, e.g. Multiple row inserts, MySQL create table options, Add drop table etc.

MySQLWorkbench

In MySQLWorkbench: App main menu > Server > Data Export

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