Live Optics | Avamar | How to Create SQL.GZ file for Avamar Upload

Summary: Live Optics allows Dell technologists, or Dell partner consultants to understand vital information about Avamar environments. Live Optics provides a simple process to gather, parse and, ultimately, present data in a clear and understandable way. The results can be used to make informed decisions about backup infrastructure. This document provides instructions on how to create the Avamar SQL.GZ file for upload. ...

This article applies to This article does not apply to This article is not tied to any specific product. Not all product versions are identified in this article.
Check out other resources

Instructions

Pre-Requisites

In order to follow the instructions below, the End-User collecting the Avamar sql.gz file must have Avamar administrative access.

Quick-Start Instructions

  • Log in to Avamar using SSH
  • Browse to the directory where the sql.gz file is to be saved
  • Issue command to GZIP Avamar SQL files
  • Verify that the file was created successfully
  • Send the sql.gz file to a Dell sales rep or Dell Partner for processing.  

Detailed Instructions

  • Connect and log in to the Avamar server using SSH
  • Go to the directory where {Avamar database file}.sql.gz file is to be saved
  • Create the {Avamar database file}.sql.gz file by issuing the following command: 
    • gzip /usr/local/avamar/var/mc/server_data/mcs_data_dump.sql -c > /tmp/mcs_$HOSTNAME.sql.gz
  • Verify that the file was saved 
    • ls -la
  • Upload the file using the Live Optics collector (select Data Protection and then Avamar).

Affected Products

PowerEdge R240, PowerEdge R250, PowerEdge R260, PowerEdge R340, PowerEdge R350, PowerEdge R360, PowerEdge R440, PowerEdge R450, PowerEdge R470, PowerEdge R540, PowerEdge R550, PowerEdge R640, PowerEdge R6415, PowerEdge R650, PowerEdge R650xs , PowerEdge R6515, PowerEdge R6525, PowerEdge R660, PowerEdge R660xs, PowerEdge R6615, PowerEdge R6625, PowerEdge R670, PowerEdge R740, PowerEdge R740XD, PowerEdge R740XD2, PowerEdge R7415, PowerEdge R7425, PowerEdge R750, PowerEdge R750XA, PowerEdge R750xs, PowerEdge R7515, PowerEdge R7525, PowerEdge R760, PowerEdge R760XA, PowerEdge R760xd2, PowerEdge R760xs, PowerEdge R7615, PowerEdge R7625, PowerEdge R770, PowerEdge R7715, PowerEdge R7725, PowerEdge R840, PowerEdge R860, PowerEdge R940, PowerEdge R940xa, PowerEdge R960 ...
Article Properties
Article Number: 000233928
Article Type: How To
Last Modified: 26 Mar 2025
Version:  3
Find answers to your questions from other Dell users
Support Services
Check if your device is covered by Support Services.