Import sample database into AWS RDS MySQL using Shell & Workbench

Photo by Tobias Fischer on Unsplash

Import sample database into AWS RDS MySQL using Shell & Workbench

Adela's photo
Adela
·Apr 6, 2022·

1 min read

Table of contents

  • MySQL Shell
  • MySQL Workbench

Bytebase open-sourced an Employee sample database for MySQL github.com/bytebase/employee-sample-databas.. with two variations: A Full dataset (~170 MB) including 300024 employee records and a Small dataset (~6 MB) including 10000 employee records.

My task was straightforward - import the small dataset into our AWS instances for demo usage.

To start, I downloaded and unzipped the file.

image.png

And opened the dataset_small. image.png

MySQL Shell

I would strictly follow the Installation instructions in Readme.

image.png

As a prerequisite, MySQL Shell was installed.

image.png

However, after installation, I still got this error - "MySQL command not found", where was the execution file?

image.png

I tried to connect to my AWS MySQL instance, and it worked!

image.png

Ensure I was under the "dataset_small" folder, then run the following -- succeeded!

mysql.png

MySQL Workbench

As MySQL Workbench was already installed locally, I would try it as well. I connected it to AWS MySQL instance Dev.

image.png

image.png

And let's import the data.

image.png

image.png

image.png

image.png

 
Share this