cancel
Showing results for 
Search instead for 
Did you mean: 

Veritas Netbackup & MySQL DB

The_Tester
Level 3

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. 

1 ACCEPTED SOLUTION

Accepted Solutions

Marianne
Moderator
Moderator
Partner    VIP    Accredited Certified

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.

View solution in original post

6 REPLIES 6

Marianne
Moderator
Moderator
Partner    VIP    Accredited Certified

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.

View solution in original post

lu
Level 6
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.

Anton_Panyushki
Level 6
Certified

I  suppose the bets bet is make a dump and grab it to a tape as a plain file.

Zahid_Haseeb
Level 6
Partner    VIP    Accredited

I think above guys told you alot but i would like to add some more things which may help you.

https://www-secure.symantec.com/connect/forums/mysql-backups-nbu

http://forums.mysql.com/read.php?28,24575,24575

Ed_Wilts
Level 6

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
Level 6
No need to export, you can also flush the data and snapshot.