AWS For Developers For Dummies
Book image
Explore Book Buy On Amazon
Data uploads normally occur when you initially set up and configure an application with AWS. You likely already have data that you want to use on a local network. The upload process sends the data from your local network to the cloud. Of course, you might also have other reasons to perform data uploads. No matter what the reason, check out how to perform a data upload by using MySQL Workbench.

This technique doesn’t transfer absolutely everything from your local or network hard drive to MySQL on the RDS server. It assumes that you simply want to move data. If you want to perform a complete transfer of a database, as might be done during an initial production move from a local network to RDS, you need to follow the much longer (and more convoluted) process in this AWS article. However, in general, this process is extreme overkill for the developer, and you likely won’t need to perform it.

Before you begin this process, you must have a local file to use for uploading to the RDS configuration, a copy of MySQL Workbench installed, and a connection to your MySQL setup on RDS. The following steps assume that you have a local or network copy of a .sql file that contains everything needed to recreate your database. You must also have the rights required to access the database on RDS, which may require superuser rights.
  1. Open MySQL Workbench and connect to RDS.

    You see the connection open as normal.

  2. Choose Server → Data Import.

    You see the Data Import page open.

    Data Import Page Use the Data Import page to configure a data upload.
  3. Choose Import from Dump Project Folder and type a location for the folder.

    The folder contains a series of scripts used to recreate the database schema and objects it contains.

  4. Choose the objects you want to import in the Select Database Objects to Import list.

    This feature is available only when you use project folders.

  5. Click Start Import.

    For a really small setup such as FirstDatabase, the process happens within a second or two.

To see the new database in Navigator, you must click the Refresh button in the upper-right corner of the display. The new database and associated objects will appear after MySQL Workbench queries RDS.

About This Article

This article is from the book:

About the book author:

John Mueller is an author and technical editor who has written 103 books. Some of his current works include Python development books. He has also written AWS For Admins For Dummies, which provides administrators a great place to start with Amazon Web Services (AWS). John has had an interest in AWS since its inception. In fact, he wrote Mining Amazon Web Services based on that humble beginning. Be sure to read John's blog at http://blog.johnmuellerbooks.com/.

This article can be found in the category: