MySQL Forums
Forum List  »  Backup

overwriting of database
Posted by: sandesh s
Date: July 13, 2017 12:44AM

i have 2 servers,server 1 is used as main backup and server 2 is used as remote backup
mysqldump -u root -p db | ssh user@192.**8.0.000 mysql -u root -p copybase
i just used the above mysql cmd to make a dump of server 1 and imported directly to a database already created in server 2.But every time when executing this mysql dump cmd,a dump is created and is sented to remote database where there already exist a previously imported file,so we need to overwrite the remote db with current dump.How can i overwrite the database with the above mysql dump cmd ?

Options: ReplyQuote


Subject
Views
Written By
Posted
overwriting of database
1439
July 13, 2017 12:44AM
449
July 13, 2017 12:46PM


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.