© The Author(s), under exclusive license to APress Media, LLC, part of Springer Nature 2023
C. BellMySQL Database Service Revealedhttps://doi.org/10.1007/978-1-4842-8945-7_7

7. Data Import and Export

Charles Bell1  
(1)
WARSAW, VA, USA
 

The DB System in MDS is clearly a very powerful and intriguing alternative to on-prem MySQL servers. We’ve seen how to create DB Systems and create backups, but what do you do when you want to get your own data into your new DB System? Or, if you want to use a copy of the data in your DB System to an on-prem development lab, how do you export the data?

Fortunately, there are methods for exporting your data and importing it to your DB System. As you will see, the process isn’t complicated and works well for most use cases. ...

Get MySQL Database Service Revealed: Running MySQL as a Service in the Oracle Cloud Infrastructure now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.