Overview of Importing and Exporting Data

This page provides an overview of importing and exporting data with Google Cloud SQL. To learn how to import data into Cloud SQL, see Importing Data. To learn how to export data from Cloud SQL, see Exporting Data. To learn how to export data for import into Cloud SQL, see Exporting Data for Import into Cloud SQL.

Best practices for importing and exporting

The following are best practices you should consider when importing and exporting data:

Use the correct flags when you create a SQL dump file

If you do not use the correct flags when you export your data to a SQL dump file, your import might not be successful. For information about creating a SQL dump file for import into Google Cloud SQL, see Creating a SQL dump file.

Compress data to reduce cost

Cloud SQL supports importing and exporting both compressed and uncompressed SQL dump files. Compression can save significant storage space on Cloud Storage and reduce your storage costs, especially when you are exporting large instances. When you export a SQL dump file, use a .gz file extension to compress the data. When you import a dump file with a file extension of .gz, it is decompressed automatically.

What's next

Send feedback about...

Cloud SQL for PostgreSQL