Running mysqldump over ssh is a simple way to copy or back up a mysql database from a remote system. Granted, it’s not suited for every scenario, but for a quick dump of the small database on my remote webserver, it’s just the thing.
Quick and dirty, got to love it 🙂
ssh -C webserver01 mysqldump -u root –password=mysecret –all-databases > mydumpfile.dmp
