DEV Community

Adela for Bytebase

Posted on

2 1

Import sample database into AWS RDS MySQL using Shell & Workbench

Bytebase open-sourced an Employee sample database for MySQL https://github.com/bytebase/employee-sample-database-mysql 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

Image of Docusign

Bring your solution into Docusign. Reach over 1.6M customers.

Docusign is now extensible. Overcome challenges with disconnected products and inaccessible data by bringing your solutions into Docusign and publishing to 1.6M customers in the App Center.

Learn more

Top comments (0)