We need automation for taking backup and restore daily base for on-prem mysql database

Tamil Selvan M 0 Reputation points
2024-02-28T12:04:25.1166667+00:00

We need automation for taking backup and restore daily base for on-prem mysql database, we using the tool for my sql is mysql- work bench

Azure Database for MySQL
Azure Database for MySQL
An Azure managed MySQL database service for app development and deployment.
726 questions
{count} votes

1 answer

Sort by: Most helpful
  1. GeethaThatipatri-MSFT 27,972 Reputation points Microsoft Employee
    2024-02-28T15:09:47.54+00:00

    @Tamil Selvan M Welcome to Microsoft Q&A thanks for posting your question.

    This tag is for Azure Mysql Database, however, to answer your question if you are running on Linux, best way is to use cron jobs and use mysqldump client tool to take backup.

    You can also check the SO here. https://stackoverflow.com/questions/44723154/using-cronjob-to-automatically-backup-mysql-files

    Regards

    Geetha

    0 comments No comments