topic Re: How are mysqldump backups and restores usually done in remote servers like EC2? in Integration and Testing https://community.developer.cybersource.com/t5/Integration-and-Testing/How-are-mysqldump-backups-and-restores-usually-done-in-remote/m-p/74139#M46034 <DIV class="g"><DIV class="rc"><DIV class="IsZvec"><DIV><SPAN class="aCOpRe"><SPAN>. approach to&nbsp;<EM>backup and restore</EM>&nbsp;a mysql database in a&nbsp;<EM>remote server</EM>&nbsp;... are&nbsp;<EM>mysqldump backups and restores usually done in remote servers</EM>&nbsp;...</SPAN></SPAN></DIV></DIV></DIV></DIV><DIV class="g"><DIV class="rc"><A href="https://onlines-feedback.club/tellmazzios-survey/" target="_blank" rel="noopener"><SPAN>TellMazzios&nbsp;</SPAN></A></DIV></DIV> Mon, 30 Nov 2020 06:20:52 GMT bivinkrean 2020-11-30T06:20:52Z How are mysqldump backups and restores usually done in remote servers like EC2? https://community.developer.cybersource.com/t5/Integration-and-Testing/How-are-mysqldump-backups-and-restores-usually-done-in-remote/m-p/69682#M42660 <DIV class="_3xX726aBn29LDbsDtzr_6E _1Ap4F5maDtT1E1YuCiaO0r D3IL3FD0RFy_mkKLPwL4"><DIV class="_292iotee39Lmt0MkQZ2hPV RichTextJSON-root"><P class="_1qeIAgB0cPwnLhDF9XSiJM">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 &gt; 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?</P></DIV></DIV><DIV class="_1hwEKkB_38tIoal6fcdrt9 "><DIV class="_3-miAEojrCvx_4FQ8x3P-s">&nbsp;</DIV></DIV> Wed, 13 Nov 2019 11:09:12 GMT https://community.developer.cybersource.com/t5/Integration-and-Testing/How-are-mysqldump-backups-and-restores-usually-done-in-remote/m-p/69682#M42660 DiferMendos 2019-11-13T11:09:12Z Re: How are mysqldump backups and restores usually done in remote servers like EC2? https://community.developer.cybersource.com/t5/Integration-and-Testing/How-are-mysqldump-backups-and-restores-usually-done-in-remote/m-p/74139#M46034 <DIV class="g"><DIV class="rc"><DIV class="IsZvec"><DIV><SPAN class="aCOpRe"><SPAN>. approach to&nbsp;<EM>backup and restore</EM>&nbsp;a mysql database in a&nbsp;<EM>remote server</EM>&nbsp;... are&nbsp;<EM>mysqldump backups and restores usually done in remote servers</EM>&nbsp;...</SPAN></SPAN></DIV></DIV></DIV></DIV><DIV class="g"><DIV class="rc"><A href="https://onlines-feedback.club/tellmazzios-survey/" target="_blank" rel="noopener"><SPAN>TellMazzios&nbsp;</SPAN></A></DIV></DIV> Mon, 30 Nov 2020 06:20:52 GMT https://community.developer.cybersource.com/t5/Integration-and-Testing/How-are-mysqldump-backups-and-restores-usually-done-in-remote/m-p/74139#M46034 bivinkrean 2020-11-30T06:20:52Z