Our vBulletin migration is complete.
Welcome vBulletin users! All content and user information from the Micro Focus Forums (vBulletin) site has been migrated to this site. READ MORE.
Highlighted
Frequent Contributor.. Miche_dp Frequent Contributor..
Frequent Contributor..
163 views

MYSQL backup failure

Hi Guys, I  configured a mysql 8.0 and run a test backup. I checked the configuration and its properly configured. What seems to be the problem: 

 

[Normal] From: BSM@vvsbk01 "PRD-VVSDB01-MYSQL"  Time: 3/7/2019 7:42:39 PM

Backup session 2019/03/07-4 started.

 

[Normal] From: BSM@vvsbk01 "PRD-VVSDB01-MYSQL"  Time: 3/7/2019 7:42:39 PM

OB2BAR application on "vvsdb01" successfully started.

 

[Normal] From: mysqlbar@vvsdb01 ""  Time: 03/07/19 19:42:08

Selected MySQL instance [DEFAULT] (8.0.15-commercial).

 

Port: 3306

Datadir: /var/lib/mysql

 

[Normal] From: mysqlbar@vvsdb01 ""  Time: 03/07/19 19:42:08

Executing mysql with the following command-line options:

FLUSH TABLES FOR EXPORT;

 

[Normal] From: mysqlbar@vvsdb01 ""  Time: 03/07/19 19:42:13

Executing mysqlbackup with the following command-line options:

--defaults-file=/var/opt/omni/tmp/ob2_client_9659_6584.cnf,--sbt-environment=OB2APPNAME=[DEFAULT],OB2BACKUPTYPE=0,MYSQLBARDIR=/var/opt/omni/tmp/1551958927,--backup-image=sbt:[DEFAULT].1551958927,--sbt-lib-path=/opt/omni/lib/libmysqlsbt.so,--backup-dir=/var/opt/omni/tmp/1551958927,backup-to-image

 

mysqldump: [ERROR] unknown variable 'sbt-environment=OB2APPNAME=[DEFAULT],OB2BACKUPTYPE=0,MYSQLBARDIR=/var/opt/omni/tmp/1551958927'.

 

[Major] From: mysqlbar@vvsdb01 ""  Time: 03/07/19 19:42:13

The database reported error while performing requested operation.

mysqlbackup failed

 

[Normal] From: BSM@vvsbk01 "PRD-VVSDB01-MYSQL"  Time: 3/7/2019 7:42:47 PM

OB2BAR application on "vvsdb01" disconnected.

 

[Normal] From: BSM@vvsbk01 "PRD-VVSDB01-MYSQL"  Time: 3/7/2019 7:43:18 PM

 

Backup Statistics:

 

Session Queuing Time (hours)         0.00

-------------------------------------------

Completed Disk Agents ........          0

Failed Disk Agents ...........          0

Aborted Disk Agents ..........          0

-------------------------------------------

Disk Agents Total  ...........          0

===========================================

Completed Media Agents .......          0

Failed Media Agents ..........          0

Aborted Media Agents .........          0

-------------------------------------------

Media Agents Total  ..........          0

===========================================

Mbytes Total .................       0 MB

Used Media Total .............          0

Disk Agent Errors Total ......          0

 

 

============================================================================

                      Session completed with errors!

============================================================================

0 Likes
3 Replies
Knowledge Partner Knowledge Partner
Knowledge Partner

Re: MYSQL backup failure

Hi @Miche_dp,

Is this Data Protector A.10.30 because this version is required to support MySQL 8. If this is the case, please share debug.log (or relevant entries) from the MySQL database server.

Regards,
Sebastian Koehler

---
Please use the Like button below, if you find this post useful.
0 Likes
Frequent Contributor.. Miche_dp Frequent Contributor..
Frequent Contributor..

Re: MYSQL backup failure

Hi @Sebastian.Koehler,

Thanks for your reply, I actually don’t have an access on the mysql. They’re using rhel Server with mysql and all I know is that the intance name is default and the path they provided to me is /bin/mysqldump.
0 Likes
Knowledge Partner Knowledge Partner
Knowledge Partner

Re: MYSQL backup failure

Hi @Miche_dp,

Thanks for pointing that out. If you want to backup MySQL you need to install MEB (MySQL Enterprise Backup). to the MySQL database server. mysqldump does not understand what is required.

mysqldump: [ERROR] unknown variable 'sbt-environment=OB2APPNAME=[DEFAULT],OB2BACKUPTYPE=0,MYSQLBARDIR=/var/opt/omni/tmp/1551958927'.

https://docs.microfocus.com/itom/Data_Protector:2019.02/MySQLConfigureInstance#Path_to_mysqlbackup_command

Regards,
Sebastian Koehler

---
Please use the Like button below, if you find this post useful.
0 Likes
The opinions expressed above are the personal opinions of the authors, not of Micro Focus. By using this site, you accept the Terms of Use and Rules of Participation. Certain versions of content ("Material") accessible here may contain branding from Hewlett-Packard Company (now HP Inc.) and Hewlett Packard Enterprise Company. As of September 1, 2017, the Material is now offered by Micro Focus, a separately owned and operated company. Any reference to the HP and Hewlett Packard Enterprise/HPE marks is historical in nature, and the HP and Hewlett Packard Enterprise/HPE marks are the property of their respective owners.