DEV Community: Satoshi Narita

How to buck up mysql's dump to AWS S3

Satoshi Narita — Mon, 12 Nov 2018 10:29:00 +0000

#! /bin/bash

db_name="YOUR_DATABASE_NAME"
db_user="YOUR_DATABASE_USER"
db_host="YOUR_DATABASE_HOST"
s3_bucket="YOUR_S3_BUCKET_NAME"
s3_key="YOUR_S3_KEY_PATH"


filename="db_dump_$( date "+%y%m%d_%H:%M:%S" ).sql"

aws s3 cp <( mysqldump -u ${db_user} -p -h ${db_host}  ${db_name} ) \
  s3://${s3_bucket}/${s3_key}/${filename}

Hello World

Satoshi Narita — Wed, 15 Nov 2017 07:55:39 +0000

Hello World

javascript

console.log("Hello World");

Rust

fn main() {
  println!("Hello World!");
}