cancel
Showing results for 
Search instead for 
Did you mean: 

How are mysqldump backups and restores usually done in remote servers like EC2?

Hi guys, I'm trying to find the best practice approach to backup and restore a mysql database in a remote server. Currently I'm using `sudo mysqldump -u root -p dbname > dbname.dump` using a script that is sent to the server, then doing an `scp` of the dump file back to my local machine in case the server crashes. How are backups and restores of mysql databases usually done in remote servers?

 
DiferMendos
Member
1 REPLY 1
. approach to backup and restore a mysql database in a remote server ... are mysqldump backups and restores usually done in remote servers ...
bivinkrean
Member