Snippets

Andrew Hawthorne bcahsn sqldump

Created by Andrew Hawthorne
View revision

File sqldump Added

  • Ignore whitespace
  • Hide word diff 
+#!/bin/bash
+
+if [ -z "$1" ]; then
+  echo -e "Like this:\nsqldump bcsu_staging\n"
+  echo -e "Databases are:\nbcsu_staging\nauth_staging\nktbc_staging"
+  exit 1
+fi
+
+DB_NAME=$1
+TMP=$(mktemp -u) && \
+
+gcloud sql export sql db1-bcahsn gs://bcahsn-sql-exports${TMP}.sql.gz --database=${DB_NAME} && \
+  gsutil cp gs://bcahsn-sql-exports${TMP}.sql.gz ./${DB_NAME}.sql.gz && \
+  gsutil rm gs://bcahsn-sql-exports${TMP}.sql.gz
HTTPS SSH

You can clone a snippet to your computer for local editing. Learn more.