Forum Discussion

The_Tester's avatar
The_Tester
Level 3
14 years ago

Veritas Netbackup & MySQL DB

Dears,

 

We have veritas netbackup 6.5 and we need backup our DB MySQL. I have not seen MySQL DB in the policy section to generate the backup, just I found MS SQL Server & Oracle.

 

Could you please guidance? And what is the best practice?  

 

Your quick respond & support highly appreciated. 

7.1.x and Earlier
Backup and Recovery
Best Practice
NetBackup
  • Marianne's avatar
    Marianne
    14 years ago

    List of NBU agents and options can be found here:

    http://www.symantec.com/business/products/agents_options.jsp?pcid=pcat_business_cont&pvid=2_1

    Unfortunately, as you can see - there is no NBU agent for MySQL.

    You need to find the MySQL command to backup/dump the database to file. You can then use a normal filesystem backup to backup the output.

    I have google'd 'How to backup MySQL' and it found ' about 3,300,000 results'. It might be better to narrow down the search to the O/S and MySQL version.

    This one seems to be a good starting point for version 5.1:

    http://dev.mysql.com/doc/refman/5.1/en/backup-and-recovery.html

     

    There are also links on the left of the screen to other MySQL versions.

6 Replies

Sort By
  • Marianne's avatar
    Marianne
    Level 6
    14 years ago

    List of NBU agents and options can be found here:

    http://www.symantec.com/business/products/agents_options.jsp?pcid=pcat_business_cont&pvid=2_1

    Unfortunately, as you can see - there is no NBU agent for MySQL.

    You need to find the MySQL command to backup/dump the database to file. You can then use a normal filesystem backup to backup the output.

    I have google'd 'How to backup MySQL' and it found ' about 3,300,000 results'. It might be better to narrow down the search to the O/S and MySQL version.

    This one seems to be a good starting point for version 5.1:

    http://dev.mysql.com/doc/refman/5.1/en/backup-and-recovery.html

     

    There are also links on the left of the screen to other MySQL versions.

  • lu's avatar
    lu
    Level 6
    14 years ago
    MySQL does not need a special agent to be backed-up For example, - you can backup a database using mysqldump then starting a FS backup - or you can flush the logs and start a filesystem snapshot and backup it. - mysqlhotcopy is another option You should read "backup and recovery" written by Curtis Preston.
  • Ed_Wilts's avatar
    Ed_Wilts
    Level 6
    14 years ago

    MySQL needs a NetBackup agent but none exists. 

    If you have a multi-terabyte MySQL database, you currently have to export the entire thing with mysqldump and then back up that file system via NetBackup so this can be a VERY lengthy process.  There's no such thing such as an incremental backup.

    This is a limitation in NetBackup and MySQL and there's no good way around it today.

  • lu's avatar
    lu
    Level 6
    14 years ago
    No need to export, you can also flush the data and snapshot.