Importing and Exporting Data
As a Cloud Engineer, you may need to perform bulk data operations, such as importing and exporting data from databases. These operations are done with command-line tools and sometimes the console. We will not look into how to programmatically insert data into databases; that is more of an application developer and database administrator task.
Importing and Exporting Data: Cloud SQL
To export a Cloud SQL database using the console, navigate to the Cloud SQL page of the console to list database instances, as in Figure 13.8.
FIGURE 13.8 Listing of database instances on the Cloud SQL page of the console
Open the Instance Detail page by double-clicking the name of the instance (see Figure 13.9).
FIGURE 13.9 The Instance Detail page has Import and Export tabs.
Select the Export tab to show the export database dialog. You will need to specify a bucket to store the backup file (see Figure 13.10).
FIGURE 13.10 Exporting a database requires a bucket...
