NetBackup™ Web UI MySQL Administrator's Guide

Last Published:
Product(s): NetBackup & Alta Data Protection (10.1)
  1. Overview
    1.  
      Overview of NetBackup for MySQL
  2. Managing MySQL instances and databases
    1.  
      Quick configuration checklist to protect MySQL instances and databases
    2.  
      Configure MySQL instance
    3.  
      Add MySQL instance
    4.  
      Manage credentials for an instance
    5.  
      Discover MySQL databases
    6.  
      Remove MySQL instances
    7.  
      Change the autodiscovery frequency of MySQL assets
  3. Managing MySQL environment credentials
    1.  
      Add new MySQL credentials
    2.  
      Default MySQL Administrator
    3.  
      Validate credentials of MySQL instance
    4.  
      View the credential name that is applied to an asset
    5.  
      Edit or delete a named credential
  4. Protecting MySQL instances and databases
    1.  
      Things to know before you protect MySQL instances and databases
    2.  
      Protect MySQL instances and databases
    3.  
      Customize protection settings for the MySQL assets
    4.  
      Remove protection from MySQL instances
    5.  
      View the protection status of MySQL instance
  5. Restoring MySQL instances and databases
    1.  
      Things to know before you restore the MySQL instances and databases
    2.  
      About the pre-restore check
    3.  
      Restore a MySQL instance and database
    4.  
      Restore target options
    5.  
      Pre-restore checks
    6.  
      Steps to perform recovery after restore operation
    7.  
      Limitations
  6. Troubleshooting MySQL operations
    1.  
      Troubleshooting tips for NetBackup for MySQL
    2.  
      Error during MySQL credential addition
    3.  
      Error during the MySQL instances and databases discovery phase
    4.  
      Error during the MySQL Protection Plan Creation
    5.  
      Error while subscribing protection plan to MySQL asset
    6.  
      Error while removing MySQL asset
    7.  
      Error while backup of MySQL asset
    8.  
      Error while restoring MySQL asset image
  7. API for MySQL instances and databases
    1.  
      Using APIs to manage, protect or restore MySQL

Steps to perform recovery after restore operation

The procedure to perform post recovery is as follows for various platforms:

For Windows (VSS):

  1. Go to Control Panel > System and Security > Administrative Tools >Services.
  2. Select MySQL service and stop it.
  3. Delete or move everything from MySQL data directory.

    Note:

    Post restore, change the attributes of the restored data directory and files by using the following command.

    attrib -S <restore_path>/*.* /S /D

  4. Copy all the contents of restored data directory to MySQL data directory.
  5. Delete all the temporary files from data directory.

    For example:

    C:\ProgramData\MySQL\MySQL Server 8.0\Data\#innodb_temp.

    Delete undo_00x files from following data directory:

    \ProgramData\MySQL\MySQL Server 8.0\

    For example:

    C:\ProgramData\MySQL\MySQL Server 8.0\undo_001

  6. Start MySQL service.

For Linux (LVM):

  1. Stop MySQL services.
  2. Copy all the contents of restored data directory to MySQL data directory.
  3. Change ownership of MySQL data directory.

    For example:

    chown -R mysql:mysql <full/path/of/MySQL/Data/Dir>

  4. Start the MySQL service.
Recovery Steps for backup done by mysqldump utility

Recover MySQL database using the mysqldump utility.

Recover single MySQL database

Below are examples of Netbackup commands which are used mostly in Windows and Linux platform.

  • For Windows:

    mysql --host=localhost --user=root --port=3306 -p netbackup < C:\mysql_dump_testjune13\mysqlBackup_Dump_xxx.sqlx

  • For Linux:

    mysql --host=localhost --user=root --port=3306 -p netbackup < /home/Single_DB_Recovery/mysqlBackup_Dump_1656932006.sqlx

Recover MySQL instance

The example commands below will create a single dump file containing all the databases.

  • For Windows:

    mysql --host=localhost --user=root --port=3306 -p < C:\mysql_dump_testjune13\mysqlBackup_Dump_xxx.sqlx

  • For Linux:

    mysql --host=localhost --user=root --port=3306 -p < /home/Entire_Instance_Recovery/mysqlBackup_Dump_1656933025.sqlx