well, you'd want to come up with your specifics but it's pretty simple using
ssh...
put this is your shell...
$ mysqldump db-name | mysql -h remote.box.com db-name
$ mysqldump db-name | ssh [EMAIL PROTECTED] mysql db-name
$ mysqldump db-name foo | ssh [EMAIL PROTECTED] mysql bar
hope this hel
If test and production are supposed to be identical, then use this:
mysqldump -h -u... -p... --triggers --routines |
mysql -h -u... -p... -A -D
If you havn't noticed, you do not dump the data to a file and ftp or scp
anything anywhere !!!
This will actually pipe all mysqldump commands striaght