{"id":4872,"date":"2021-08-31T08:52:23","date_gmt":"2021-08-31T07:52:23","guid":{"rendered":"http:\/\/dasini.net\/blog\/?p=4872"},"modified":"2021-09-14T08:46:54","modified_gmt":"2021-09-14T07:46:54","slug":"discovering-mysql-database-service-episode-5-create-a-mysql-db-system-from-a-mysql-shell-dump","status":"publish","type":"post","link":"https:\/\/dasini.net\/blog\/2021\/08\/31\/discovering-mysql-database-service-episode-5-create-a-mysql-db-system-from-a-mysql-shell-dump\/","title":{"rendered":"Discovering MySQL Database Service – Episode 5 – Create a MySQL DB system from a MySQL Shell dump"},"content":{"rendered":"\n

MySQL<\/a>, the world’s most popular open source database<\/strong>, is available as a managed cloud service<\/strong> in Oracle Cloud Infrastructure<\/a><\/strong> (OCI<\/a><\/strong>) under the name of MySQL Database Service<\/a><\/strong> (MDS<\/a><\/strong>).<\/p>\n\n\n\n

MySQL Database Service is a fully managed cloud service, 100% Developed, Managed and Supported by the MySQL Team.<\/strong><\/p><\/blockquote><\/figure>\n\n\n\n

This is the fifth<\/span> episode of \u00ab\u00a0Discovering MySQL Database Service<\/a><\/em><\/strong><\/em><\/strong>\u00ab\u00a0, a series of tutorials where I will show you, step by step, how to use MySQL Database Service and some other Oracle Cloud Infrastructure services. <\/p>\n\n\n\n

Please also note that you can run this tutorial and thus try MySQL Database Service & the other Oracle Cloud Infrastructure services for free<\/span><\/strong> by starting your 30-day trial<\/a>.<\/p>\n\n\n\n

\"MySQL<\/figure><\/div>\n\n\n\n
\n

Planning episodes<\/h2>\n\n\n\n
  1. Introduction to the series Discovering MySQL Database Service<\/em><\/strong><\/a> <\/li>
  2. Create a compartment<\/a><\/li>
  3. Create a Virtual Cloud Network<\/a><\/li>
  4. Dump your MySQL data into an Object Storage bucket<\/a><\/li>
  5. Create a MySQL DB system from a MySQL Shell dump<\/a><\/li>
  6. Update the Private Subnet Security List<\/a><\/li>
  7. Use a Bastion SSH port forwarding session<\/a><\/li>
  8. Connect to MySQL Database Service Using MySQL Shell<\/a><\/li>
  9. Connect to MySQL Database Service Using MySQL Workbench<\/a><\/li>
  10. Connect to MySQL Database Service Using OCI Cloud Shell<\/a><\/li>
  11. MySQL Database Service Features Overview<\/li><\/ol>\n<\/div><\/div>\n\n\n\n

    <\/p>\n\n\n\n

    <\/div>\n\n\n\n

    Episode 5 – Create a MySQL DB system from a MySQL Shell dump<\/h1>\n\n\n\n

    In the previous episode<\/a> we’ve seen how to export data from a MySQL instance to an Oracle Cloud Infrastructure bucket using the awesome MySQL Shell. One more step to our Discovering MySQL Database Service<\/em><\/strong> journey. <\/p>\n\n\n\n

    In this episode, we’ll see how these data can now easily be imported into a MySQL Database Service instance.<\/p>\n\n\n\n

    <\/div>\n\n\n\n

    The workflow<\/h2>\n\n\n\n

    Again, the workflow is quite simple.
    It is the continuation of the process initiated during the previous episode:     Discovering MySQL Database Service \u2013 Episode 4 \u2013 Dump your MySQL data into an Object Storage bucket<\/a>.<\/p>\n\n\n\n

    We will create a MySQL Database Service instance which will contain the data from the MySQL Shell<\/a> dump stored inside the Oracle Cloud Infrastructure object storage bucket<\/a>.<\/p>\n\n\n\n

    \"\"<\/figure>\n\n\n\n

    Thus the needed components are:<\/p>\n\n\n\n