Highlighted

MYSQL backups

Master & Media - NBU 5240 Appluiance 3.1.2

Client - Windows 2019 standard, NBU 8.1.2, MYSQL 5.7.29

I am trying to configure MYSQL backups using MYSQL agent. Just curious to know if there is any script (like Linux) which we can use to schedule backups from Netbackup?

If no, then how can we schedule backups automatically?

 

Tags (2)
6 Replies
Highlighted

Re: MYSQL backups

@NBU35 

Yes, you can. This is explained in NBU for MySQL manual, which contains a link to this article: 
https://www.veritas.com/support/en_US/article.100041374

Highlighted

Re: MYSQL backups

Put below into a bat file and call it from the policy.

@REM
set CMD_LINE="C:\Program Files\Veritas\NBMySQLAgent\nbmysql" -o backup
echo %CMD_LINE%

%CMD_LINE%

if errorlevel 1 goto errormsg
echo BRBACKUP successful
if "%STATUS_FILE%" == "" goto end
if exist "%STATUS_FILE%" echo 0 > "%STATUS_FILE%"
goto end

:errormsg
echo Execution of BRBACKUP command failed - exiting
if "%STATUS_FILE%" == "" goto end
if exist "%STATUS_FILE%" echo 1 > "%STATUS_FILE%"

:end

Highlighted

Re: MYSQL backups

this script is only for LINUX, not for windows.

Highlighted

Re: MYSQL backups

do I have to change any parameter in this script ?

Highlighted

Re: MYSQL backups

@NBU35 

Did you see these lines in the TN? 

Disclaimer:
Please note that this script is provided as is and is a sample script only. The script is not supported by Veritas technical support.
It is the responsibility of the customer to modify the script to take into account specific requirements and variables in his/her environment.

@bhdrkzltn posted a Windows script.
Work with your MySQL dba to modify the script (like you would do with a MS-SQL or Oracle script-based backup). 

Highlighted

Re: MYSQL backups

@NBU35 it is a Windows "batch" script.