[SOLVED] Download backup MariaDB and volumes or migrate to another server

Could anyone help me with the propper comand in ssh to download back up or/and migrate data from MariaDB and volumes

I check this articule to test in appwrite to ensure data in ssh, not just use server service of back ups, double backup will be more secure for data and volumes, and I think faster to migrate appwrite.

https://dev.to/appwrite/appwrite-in-production-backups-and-restores-4beg

It works fine in my test, for dump data of MariaDB in dump.sql and store it. Show all DB and table, backup them and make changes, restore from backup and all data was restore properly

But I don't know how I can access that dump.sql, to downlod, for migrate I see the comand, don't know if its works, didn´t try now, just try to download

The comand to migrate that I saw is that

rsync -avz --progress /root/appwrite/dump.sql root@[targetServer]:/root/appwrite/dump.sql

Any idea about sintax for download and migrate, if you could explain in detail, thanks a millon, don't have skills of devopps, just basic skills

It sounds like you're asking about how to transfer files to and from servers. If so, you can use scp. There are also GUI tools that use scp under the hood like cyber duck

Thanks Steven, scp?, what's that, I use google and I'm in spain, mother of God the search results with acronyms is so hard, did't find nothing about that

Sorry, secure copy: https://haydenjames.io/linux-securely-copy-files-using-scp/

Thanks a million Steven, I found crazy things in spanish, oh my God, about laws. Lemmy is God, and Steven his prophet 😀

[SOLVED] Download backup MariaDB and volumes or migrate to another server