cancel
Showing results for 
Search instead for 
Did you mean: 

MYSQL backups

NBU35
Level 6

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?

 

6 REPLIES 6

Marianne
Moderator
Moderator
Partner    VIP    Accredited Certified

@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

bhdrkzltn
Level 4

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

this script is only for LINUX, not for windows.

do I have to change any parameter in this script ?

Marianne
Moderator
Moderator
Partner    VIP    Accredited Certified

@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). 

sdo
Moderator
Moderator
Partner    VIP    Certified

@NBU35 it is a Windows "batch" script.