Easy way to do a mysqldump and restore using netcat (this is NOT encrypted)

NC-MySQLDUMP.sh

#####
# You'll be needing two machines, the target machine and source one (makes sense, right)?

#####
# On the target machine
nc -l 55555 | gzip -d -c | mysql <database name> -u<user> -p<password> [ | <decrypt> ]

#####
# On the source machine
mysqldump -u<user> -p<password> <database name> | gzip | nc <ip of target server> 55555 [ | <encrypt> ]

#####
# Adding Encryption...

# Encrypting with openssl
/usr/bin/openssl enc -aes-256-cbc -pass pass:<some_password> -e

# DECRYPTING THE FILE
# /usr/bin/openssl enc -aes-256-cbc -pass pass:<some_password> -d

How does encryption work here on the fly...?

With stream cipher encryption enabled...

#!/bin/bash

#####
# On the target machine
nc -l 55555 | openssl enc -d -aes-128-cfb -pass pass:<password> | gzip -d -c | mysql <database name> -u<user> -p<password>

#####
# On the source machine
mysqldump -u<user> -p<password> <database name> | gzip | openssl enc -aes-128-cfb -pass pass:<password> | nc <ip of target server> 55555