MySQL backup

It will not be consistent. 
Veeam Agent for Windows do not have a mysql integration.

You need to work with pre freeze Scripts, to get the mysql db in a consistent state before windows creates the vss snapshot.

https://helpcenter.veeam.com/docs/agentforwindows/userguide/pre_post_scripts.html?ver=50

But if you do a server managed agent job you can configure application aware backup for MS SQL.

I haven’t done this for a server managed agent job, so, no guarantee that it will work. But it is worth trying….

Only for Veeam Agent for Linux.

Not for Windows Systems. He is asking for windows Agent specifically. 

Mhh, the configuration menues are there for Windows, too.

As I said before, I haven’t tried it so far…. And I don’t have a test maschine for this scenario at the moment.

@JMeixner 

SQL is for MSSQL, not MySQL.

Windows:

Linux:

Oh, cannot read today. Indeed, @Anandu says MySQL…

Ok, ok, my mistake

Mildur wrote:

@JMeixner

SQL is for MSSQL, not MySQL.

Windows:

Linux:

 

 

it’s always a pleasure to read you @Mildur 

Mildur wrote:

@JMeixner

SQL is for MSSQL, not MySQL.

Windows:

Linux:

 

 

Interesting to see the Linux window showing MySQL. Looks like as you mentioned scripts are the way.

My Sys Admin installed Veeam Agent on the target Linux/MySQL server.  I had to create a veeam account in the MySQL database to allow him to log into the MySQL instance.  The Veeam for Linux application  logged into the MySQL server, flushed and locked the MyISAM tables, took the snapshot, and then unlocked the MyISAM tables.  However, Veeam for Linux did not touch the InnoDB tables (the newer standard).  Does anyone know if the InnoDB tables need to be flushed before taking a backup snapshot or not.  Veeam backup snapshots each logical volume when doing a full VM server backup to include the logical volume that contains the data directory (/var/lib/mysql).  I am wondering if I now have a consistent backup or not in regard to  the InnoDB tables.

The easiest way to tell would be to do a restore and check the database tables in question.  You can also check this forum post on InnoDB - Backup MySQL Databases of a VM in VMware - R&D Forums (veeam.com)