Error importing SQL dump from bucket (exported from Google Cloud Console)
233 views
Skip to first unread message
Brett Peary
Apr 25, 2018, 12:58:57 PM4/25/18
to Google Cloud SQL discuss
I have a Google App Engine project running Wordpress and everything is working fine on that. I exported the Cloud SQL instance to a bucket in that project and then transferred to a bucket in an new Google App Engine project where I want to import the SQL instance.
The last command gives me the following in the command line utility..and " gs://import-myapp-wp-app-v2/Cloud_SQL_Export_2018-04-24 (20:48:52)/: Not found (bad bucket name?)" in the Console's operations log.
The documentation says that if you have "ERROR_RDBMS" that it is probably related to permissions and did not elaborate.Since I exported the SQL dump from Cloud SQL, I thought that it would have the correct permissions need to import back in to Cloud SQL.
I've tried importing through the Google Cloud Console, but I get an unknown error, so I switched to the command line utility.
Here are the commands I've run following the doc here...
gcloud sql instances describe myapp-wp-db-app-v2
// the serviceAccountEmailAddress (a fake version of it)
// gsutil acl ch -u [SERVICE_ACCOUNT_ADDRESS]:W gs://[BUCKET_NAME]gsutil acl ch -u hvintl4c5h3...@sparkle-boots-23.iam.gserviceaccount.com:W gs://import-myapp-wp-app-v2
// gsutil acl ch -u [SERVICE_ACCOUNT_ADDRESS]:R gs://[BUCKET_NAME]/[IMPORT_FILE_NAME]gsutil acl ch -u hvintl4c5h3...@sparkle-boots-23.iam.gserviceaccount.com:R gs://import-myapp-wp-app-v2/Cloud_SQL_Export_2018-04-24 (20:48:52)/
// gcloud sql import sql [INSTANCE_NAME] gs://[BUCKET_NAME]/[IMPORT_FILE_NAME] \ --database=[DATABASE_NAME]gcloud sql import sql myapp-wp-db-app-v2 gs://import-myapp-wp-app-v2/Cloud_SQL_Export_2018-04-24 (20:48:52)/ \ --database=wordpress_db
Importing data into Cloud SQL instance...failed.ERROR: (gcloud.sql.import.sql) ERROR_RDBMSThis command below (without a trailing slash) give me unknown error...
gcloud sql import sql myapp-wp-db-app-v2 gs://import-myapp-wp-app-v2/Cloud_SQL_Export_2018-04-24 (20:48:52) \ --database=wordpress_dbThe documentation says that if you have "ERROR_RDBMS" that it is probably related to permissions and did not elaborate.Since I exported the SQL dump from Cloud SQL, I thought that it would have the correct permissions need to import back in to Cloud SQL.
Any idea how to handle this?
Cheers.
Kamran (Google Cloud Support)
Apr 25, 2018, 8:05:21 PM4/25/18
to google-cloud...@googlegroups.com
On Wednesday, April 25, 2018 at 12:58:57 PM UTC-4, Brett Peary wrote:
I have a Google App Engine project running Wordpress and everything is working fine on that. I exported the Cloud SQL instance to a bucket in that project and then transferred to a bucket in an new Google App Engine project where I want to import the SQL instance.I've tried importing through the Google Cloud Console, but I get an unknown error, so I switched to the command line utility.Here are the commands I've run following the doc here...
// the serviceAccountEmailAddress (a fake version of it)
The last command gives me the following in the command line utility..
Brett Peary
Apr 25, 2018, 8:15:56 PM4/25/18
to Google Cloud SQL discuss
Thank you. This post was a duplicate. I didn't not see the notification saying that the post will be reviewed, and I thought I had lost it, so I wrote another one.
I was able to get around my import issue by using the Console. I read in another thread that you have to export and import specific databases not a whole instance.
Reply all
Reply to author
Forward
0 new messages