Hi;
What I understand from your brief is that, you need a "manual" for these operations described.
I can provide instructions and shoot some videos for better explaining the concept.
I will need some details like your server setup. Rest is easy - I can also write some scripts to easily backup your MySQL / MariaDB server if you need to, if you are not comfortable using MySQL CLI, which is used to make backups or restore them - normally, you wont need MySQL CLI as PHPMyAdmin already do the job, but if your backups are too big, PHPMyAdmin can fail for a few reasons, like PHP upload limit is lower than the backup size, or huge backup files like over 500 MB compressed cannot be handled by PHPMyadmin, as PHP itself would consume a lot of resources like memory and CPU power.
Please feel free to contact me and ask whatever you need.
Best regards,
Baris Atasoy