mysql

Remote MySQL Dump into local DB


#!/bin/bash

DB=$1
shift

TABLES=$*


ssh -C colin@db2 "mysqldump -u root --password='heLL&*()0' --skip-lock-tables $DB $TABLES > /tmp/load.sql && gzip -c /tmp/load.sql" > /tmp/load.sql.gz && gunzip -c /tmp/load.sql.gz | mysql -u root $DB

Tags:

Code
mysql