dev-scripts/scripts/octobercms/import-db-from-remote.sh

10 lines
305 B
Bash
Executable File

#!/bin/sh
_remote_mysql_user='qfyjgprzay'
_remote_mysql_pass='XgxJ5vTbz2'
_remote_mysql_db='qfyjgprzay'
ssh octobercms@staging.rayelliott.dev "mysqldump -u$_remote_mysql_user -p$_remote_mysql_pass $_remote_mysql_db | gzip -9" > dbremote.sql.gz
gunzip dbremote.sql.gz
mysql -uroot october < dbremote.sql