Solution for MySQL Server on Windows

[RoscoT]

Hello all,

I've spent a couple of hours looking into this but feel I'm not much closer to finding a solution.

As others on this forum have mentioned, all the documentation appears to revolve around MySQL running on Linux.

I understand that the options available to me are:

• Hot Backup — Database Dump
  Hot Backup — Database Freeze
  Cold Backup - Database shutdown

Looking at the pros and cons I believe the "Hot Backup — Database Freeze" option would be fine for me.
Has anyone actually successfully set this up for MySQL on Windows?

It would be great if there was a proper guide on this with step by step instructions and example scripts.

Cheers,

Ross

[nielsengelen]

Hi Ross,

There is actually a whitepaper on this topic available and the same applies for Windows.

I would suggest to use database dumps or benefit from the build-in PIT feature using the binary log.

[RoscoT]

Hello Niels,

Thanks for the reply. Yes, I had read through that document but the example scripts are Bash shell script files which are no use on a Windows server. I wouldn't know how to convert those pre-freeze and post-thaw scripts to Powershell scripts. I'm sure someone has managed that though so my hope is that they can be shared. Would someone at Veeam have the Powershell equivalent scripts? Should I raise a support ticket for this?

Kind regards,

Ross

[RoscoT]

Actually I've just Googled Powershell and MySQL dumps and that's given me enough to go on. I'll look to post some example scripts once I get it working.