#!/bin/bash

user="tails-bi"
pw="BI PASSWORD"
host="tails-live-db-bi.ccb0pphz4id7.eu-west-1.rds.amazonaws.com"
db="tails_default"
table="$1"
dump="/SOMELOCALFOLDER/${db}_${table}.sql"

echo "Dumping $db.$table to $dump..."
mysqldump --single-transaction -u $user --password="$pw" -h $host $db $table > $dump

user="YOURLOCALUSER"
pw="YOURLOCALPASS"
host="localhost"
db='tails_default'

echo "Importing $db.$table to local database..."
mysql -u $user --password=$pw -h $host -D $db < $dump