I want o daily backup my database to a local machine throught a automatic process (isn't necessary all tables).
My goal is to call this backup database from another databases to complement information and ultimately communicate with Power Bi.
But as I have Magento cloud, and the comunication is trought a SSH tunnel, I don't know how to do this...
Can you help me?
Since you noted you don't necessarily need all tables, can you utilize the scheduled export? - https://experienceleague.adobe.com/docs/commerce-admin/systems/data-transfer/data-scheduled-import-e...
Its a great option, however I need to export some tables from a specific extension.. And this option can only export specific things like products...
1. Use the Magento CLI to run scheduled SSH cron jobs for database dumps saved locally.
2. Write a PHP script to connect via SSH tunnel and run mysqldump on a schedule, saving backups locally.
Ensure proper security controls are in place. Test restoration process as well.