Loading Data into the MySQL Database

You load data into a MySQL database on MySQL Cloud Service using the same tools you would use for a MySQL database on your system or in your data center. The fact that the database is housed in the Oracle Cloud does not place any restrictions on data loading.

However, transmission speeds across the Internet tend to be slower, sometimes much slower, than on internal networks, and any data loading approach that you use should factor this in. For the sake of efficiency, therefore, it is recommended you move the files containing the data on to a compute node associated with MySQL Cloud Service using a single bulk transfer before the data-loading operation is performed. Consequently, the processing associated with the data loading operation occurs within the MySQL Cloud Service environment and proceeds more rapidly.

For more information on how to load data into your MySQL Server, see MySQL 5.7 Reference Manual.

Note:

It is also possible to instantiate a MySQL Cloud Service deployment using a backup stored in a cloud container. For more information, see Creating a MySQL Server Deployment.