I’ve been searching for stuffs like this:

  • How to Automate MySQL Database Backups in Linux

I am not getting good enough ideas. This is very easy and the task isn’t clear as I don’t do work with databases that much. Can you guide me a bit on projects? My constraint is my machine is very weak i5 7th gen…So I can’t do ELK stuffs for log analysis in microservices.

4 Spice ups

I would think not automate but schedule the backup jobs ?

Hmmm do you’ve any tasks that need automation? I’ve none.

Are you asking what tasks can or should be automated or are you specifically asking how to automate MySQL database backups?

First one.

This?

It’s not helpful if you give replies that are not clear.

Generally, you automate things you do repetitively, things that are usually the same - creation of user accounts, picking the users from a csv with firstname, surname and payroll number for example.

Creating snapshots or checkpoint before patching or rebooting servers on schedules to give them a clean slate.

Renewing certificates for websites.

You should already be automating backup of VMs and physical servers, for example on a schedule.

What you automate depends on what you see as repetitive. What do you do often that seems like it would fit by being done on a schedule, for you?

You need to find what to automate on your own.

Couple of tips… look for things that

  1. Are done on a regular basis. Repeatable.
  2. Have well defined procedures/steps for.