In order to create more 'data recovery' points than the standard automatic backup policy allows, I'm going to run a cron which will export sql dumps out of my CloudSQL instances at intervals throughout the day. I know I can do this using the gcloud command as follows:

cloud sql export sql [INSTANCE_NAME] gs://[BUCKET_NAME]/sqldumpfile.gz \
    --database=[DATABASE_NAME] --table=[TABLE_NAME1,TABLE_NAME2, ...]

There is not much info on Google support docs as to what is actually happening here. What's important to me is whether this process causes tables to be locked on export like a mysqldump command would (without the appropriate flags)

I know that the gcloud export function includes the --skip-triggers flag, but there is no information about table locking. Can anybody help?

  • Any particular reason you don't want to ask Google support, for which you are probably paying? – mustaccio Jan 23 at 13:25

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Browse other questions tagged or ask your own question.