Magento Forums
Help
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

How to daily backup my database on Magento Cloud

‎09-04-2023 03:20 AM
‎09-04-2023 03:20 AM

How to daily backup my database on Magento Cloud

Hi everyone!

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?

0 Kudos
Reply
3 REPLIES 3
‎09-04-2023 05:17 AM
‎09-04-2023 05:17 AM

Re: How to daily backup my database on Magento Cloud

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...

Founder at https://agency418.com
Reply
‎09-04-2023 07:12 AM
‎09-04-2023 07:12 AM

Re: How to daily backup my database on Magento Cloud

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...

 

Thank you!

0 Kudos
Reply
‎09-26-2023 01:57 AM
‎09-26-2023 01:57 AM

Re: How to daily backup my database on Magento Cloud

 

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.

0 Kudos
Reply