Reply
Member
Posts: 1
Registered: ‎11-13-2019

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?