MySQL Forums
Forum List  »  General

mysqldump remote host
Posted by: Jeremy R
Date: January 23, 2018 11:48AM

I am looking to make a script to backup a webserver to my NAS. For security reasons I want to pull from the NAS. I already have the keys made, and I can SSH into the remote box. I am lost as to tell the remote box where to dump the .sql file.

So far what I have come up with is the following from the NAS.
mysqldump - h webserver.com - u backup -p backup db1 > ???/db1.sql

what goes in the ??? part? I want to drop it into a specific directory on my NAS. Is it the path to where I want to dump the file on the local machine?

so db1 > /path/to/NAS/directory/db1.sql

Options: ReplyQuote


Subject
Written By
Posted
mysqldump remote host
January 23, 2018 11:48AM
January 28, 2018 12:26AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.