11-13-2019 03:09 AM
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?
11-29-2020 10:20 PM