liveBook · Manning

Data dump

As explained in Amazon Web Services in Action, Third Edition: An in-depth guide to AWS

A database dump is a file containing exported database structure and data in a form that can be restored or imported.

A data dump is a file containing exported database structure and data that can be restored or imported. It transfers an existing database into a new environment, such as Amazon RDS. section 10.2

Use a dump to move a database into RDS:

  • Export the source database with a database-specific tool such as mysqldump. section 10.2
  • Run a virtual machine in the same AWS Region and VPC as the RDS database. section 10.2
  • Upload the dump to the virtual machine, then import it into RDS with the database client. section 10.2
$ mysqldump -u $UserName -p --all-databases > dump.sql

Export all databases, a selected database, or a network-connected database with mysqldump. section 10.2

How Amazon Web Services in Action, Third Edition: An in-depth guide to AWS covers it

How deep it goes
Explains export, transfer, and import steps with MySQL commands, while deferring detailed export syntax to documentation.
Examples
Uses a WordPress migration, dump.sql exports, and importing wordpress-import.sql into an RDS database.
What it assumes
Assumes access to a source database, an RDS instance, a virtual machine, and suitable database credentials.
What you can do after
Apply it via MySQL command-line tools to export a database and import the resulting file into RDS.
How it connects
Connects database dumps with MySQL, mysqldump, database clients, virtual machines, and Amazon RDS.
Cover of Amazon Web Services in Action, Third Edition: An in-depth guide to AWS
liveBookmanning.com
Read Amazon Web Services in Action, Third Edition: An in-depth guide to AWS on liveBook Get the book at manning.com

Related concepts

This explainer was generated by Manning's knowledge graph from the text of Amazon Web Services in Action, Third Edition: An in-depth guide to AWS. The section links point to the parts of the book it draws on.