Hey guys, I have a question.
In a windows system with MySQL database, if I install veeam agent for windows, will I able to backup MySql database?
Solved
MySQL backup
Best answer by Mildur
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
+12It 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
Product Management Analyst @ Veeam Software
+17But 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….
Jochen (Joe) Meixner | Veeam Vanguard 2024 | Veeam Legend 2021 - 2024 | Veeam Certified Architect (VMCA) | Twitter: @JoMeix | BlueSky: @jmeixner.bsky.social
+12JMeixner wrote:
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, but it is worth trying….
Only for Veeam Agent for Linux.
Not for Windows Systems. He is asking for windows Agent specifically.
Product Management Analyst @ Veeam Software
+17Mildur wrote:
JMeixner wrote:
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, but it is worth trying….
Only for Veeam Agent for Linux.
Not for Windows Systems.
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.
Jochen (Joe) Meixner | Veeam Vanguard 2024 | Veeam Legend 2021 - 2024 | Veeam Certified Architect (VMCA) | Twitter: @JoMeix | BlueSky: @jmeixner.bsky.social
+12
Product Management Analyst @ Veeam Software
+17Oh, cannot read today. Indeed,
Ok, ok, my mistake 
Jochen (Joe) Meixner | Veeam Vanguard 2024 | Veeam Legend 2021 - 2024 | Veeam Certified Architect (VMCA) | Twitter: @JoMeix | BlueSky: @jmeixner.bsky.social
+13Backups are like pizza, I love them. | Linkedin: @marco-fabbri-it
+21Mildur wrote:
Interesting to see the Linux window showing MySQL. Looks like as you mentioned scripts are the way.
Chris Childerhose - VMCA2024 | VMCE2023 | VMCE-SP2024 | Veeam Vanguard 8* | Veeam Legend 5* | vExpert 6* | VCAP-DCV/VCP-DCV | Object First Ace | Cisco Champion | Twitter: @cchilderhose | Blog Site – https://just-virtualization.tech
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.
1 person likes this
+21ShaneFurlong wrote:
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)
Comment
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.