Skip to Navigation

Muffinlabs!

Home ›

Remote MySQL Dump into local DB

  1. #!/bin/bash
  2.  
  3. DB=$1
  4. shift
  5.  
  6. TABLES=$*
  7.  
  8.  
  9. 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
Categories: