Advertisement
Guest User

Untitled

a guest
Jul 1st, 2016
100
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.37 KB | None | 0 0
  1. ssh -i ~/.vagrant.d/insecure_private_key 192.168.100.109 '
  2. HOST='0.0.0.0'
  3. USERNAME=root
  4. PASSWORD=root
  5. DATABASE=mystore2
  6. TABLES='mysql --host=$HOST --user=$USERNAME --password=$PASSWORD --database=$DATABASE --batch --silent --execute \'SHOW TABLES LIKE \'chips_%\'\''
  7. mysqldump --host=$HOST --user=$USERNAME --password=$PASSWORD --no-data $DATABASE $TABLES
  8. ' > test.sql
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement