In such cases, you are not supposed to use a system user (such as root@localhost) as the DEFINER for triggers, view, or stored procedures. Cloud SQL is a managed environment, and the root user has all privileges except SUPER and FILE. You should formulate your queries accordingly.
1. Go to the Cloud SQL Instances page in the Google Cloud Console.
2. Select the instance to open its Overview page.
3. Click Import in the button bar.
4. Under Choose the file you'd like to import data from, enter the path to the bucket and SQL dump file to use for the import. Or to browse to the file:
a. Click Browse.
b. Under Location, double-click the name of the bucket in the list.
c. Select the file in the list.
d. Click Select.
You can import a compressed (.gz) or an uncompressed (.sql) file.
5. For Format, select SQL.
6. Select the database you want the data to be imported into.
This causes Cloud SQL to run the USE DATABASE statement before the import.
* If your SQL dump file includes a USE DATABASE statement, it overrides the database you set in the console.
7. Click Import to start the import.