Importing Dump File in Google Cloud SQL Instance

Steps:

The following steps to be followed:-

1. Goto Overview tab in Cloud SQL Instance and click Edit Configuration

2. Save the instance.

3. Sql dump file - If the sql dump file contains keyword as DEFINER then remove the line DEFINER = ‘root’@’localhost’ from the sql dump file. Save and upload the file in google cloud storage.

4. Enter into the instance, click on Import, select the sql dump file location from cloud storage, select SQL as import format, expand show advanced options - and select database name from the drop down list.

5. Click on import.

6. You will get a message Import from gs://folder_name/sql_dump_file.sql succeeded, on successful import of file.

7. Connect via sql workbench and access the imported database.