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
Subject
Written By
Posted
mysqldump remote host
January 23, 2018 11:48AM
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.