liveBook · Manning

Database import

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

Database import is the process of loading database structure and data from an external source into a target database.

Database import loads database structure and data from an external source into a target database. A common migration moves a MySQL dump from an on-premises WordPress installation into Amazon RDS. section 10.2

Use this migration sequence:

  • Export the source database into a dump file, commonly with the MySQL mysqldump command-line tool. section 10.2
  • Start a virtual machine in the same AWS Region and VPC as the target RDS database. section 10.2
  • Upload the dump to the virtual machine, then run the MySQL client against the RDS endpoint. section 10.2

Import a WordPress dump

Download the dump and import it through the target database account: mysql --host $DBAddress --user wordpress -p < wordpress-import.sql section 10.2

$ mysqldump -u $UserName -p --all-databases > dump.sql

Browse a command that exports all MySQL databases to dump.sql; related listings cover selective and network exports. section 10.2

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

How deep it goes
Defines the workflow and commands, but skips the actual export procedure in the worked scenario.
Examples
Uses a WordPress migration, mysqldump exports, an S3-hosted SQL file, and mysql import commands.
What it assumes
Assumes access to a source database, an RDS instance, a virtual machine, and MySQL command-line tools.
What you can do after
Operate/configure a MySQL dump migration into an RDS database through a same-VPC virtual machine.
How it connects
Connects database dumps with MySQL, mysqldump, Amazon RDS, virtual machines, VPCs, and WordPress.
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.