Azure Database for MySQL server

  1. Choose a Restore point;

    From your use patterns or log entries, find out a restore point when you know your DB is working well at that paticular moment. You can go back up to 35 days ago (as configured).

    Note that time is UTC based for Azure restore feature.

    Azure Database for MySQL server - Resotre

  2. Restore to a new Azure Database for MySQL server;

    Depending on the size of your database, it will take some time to finish.

  3. Re-configure VNET rules if needed;

    VNET rules in connection security are not copied over to the new MySQL server. Firewall rules and SSL settings are kept though.

  4. Check server parameters;

    Server parameters are supposed to be carried over to the newly restored server. Check it for sure.

    Note: time_zone is an exception; new servers default to SYSTEM.

  5. Update application to use new database host and username;

    With Database data, server configuration and connection security validated, update your application to use the new database host and username.

    Note that Azure Database for MySQL encompasses server name into database login name, so your username will get changed after restoration.

  6. Restart your application if needed.

    And run your tests.