Collection instructions for SQL.GZ files for Avamar profile

Live Optics Agent


Live Optics allows you, your Dell EMC technologists, or Dell EMC partner consultants to understand vital information about your Avamar environment. To start, it is important to gather the pertinent data files of your backup environment. Live Optics provides you with a simple process to gather, parse and, ultimately, present your data in a clear and understandable way, so that you can make informed decisions to optimize your backup infrastructure.


In order to follow the instructions below, the End User collecting the Avamar SQL.GZ files must have administrative access to Avamar Grid.

Quick-Start Directions

  1. Login to Avamar using SSH
  2. Navigate to directory where SQL.GX file will be saved
  3. Issue command to GZIP Avamar SQL files
  4. Verify the file was created successfully
  5. Send SQL.GZ file to Dell EMC sales rep or Dell EMC Partner for processing.  

Detailed Instructions

Step 1: Login to Avamar via SSH

  • Using your favorite SSH client, connect to your Avamar server 

Step 2: Navigate to directory where SQL.GX file will be saved

  • Use the cd command to navigate to a directory where the Avamar file will be saved


Step 3: Create SQL.GZ file

  • Use the following command to create the SQL.GZ file in your directory

gzip –c /usr/local/avamar/var/mc/server_data/mcs_data_dump.sql >/tmp/mcs_$HOSTNAME.sql.gz


Step 4: Verify the file was saved in your directory

  • From the directory where you saved the SQL.GZ file, type "ls -la" to verify the SQL.GZ file is listed


Step 5: Send files to Dell EMC sales team or Dell EMC partner for processing

  • The sales team that receives your file will generate a PPTX report for Avamar and send it back to you for review.
Was this article helpful?
0 out of 0 found this helpful
  • 0

    Lukas Volkening


    The comment mentioned has not the right syntax. The -c musst follow the filename. Otherwise gzip tries to zip -c which doesn't work, following it zips the original file and at the end creates an empty file with the given name.

    Here is the correct syntax:
    gzip /usr/local/avamar/var/mc/server_data/mcs_data_dump.sql -c > /tmp/mcs_$HOSTNAME.sql.gz

    Comment actions Permalink
  • 0

    Ryan McKee

    Thanks for the correct syntax.  Also we need to update this guide so it instructs the customer to use WinSCP (or something similar) to navigate to root /tmp and download the gzip from the appliance to local desktop to upload to the LO Collector.  

    Comment actions Permalink
  • 0

    Robert Gregory

    So Ryan, Why were these instructions not updated yet?

    Could save us lots of headaches.

    When do you think the instructions will be updated?


    Comment actions Permalink
Please sign in to leave a comment.