Bakcup MySQL DB:
mysqldump -h [DB server name] -u [username] –p[password] [database_name] > [dump_file.sql]
mysqldump -h WILLOW.SAFESECUREWEB.COM -u cxxxy -pxxxxxx yyyyyyy > xxxxx.sql
Restore the backup to a remote database server:
mysql –h [hostname] –u [username] –p[password] [database_name] < [dump_file.sql]
mysql -h WILLOW.SAFESECUREWEB.COM -u xxxxxx -pxxxxxx yyyyyyy < xxxxxxx.sql
File Transfer: server to server
rsync -avz xxx.sql [email protected]:/home/88/82/2028288/web (HW Hosting Space)