cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted

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. 

1 Solution

Accepted Solutions
Highlighted
Accepted Solution!

List of NBU agents and

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
Highlighted
Accepted Solution!

List of NBU agents and

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

Highlighted

MySQL does not need a special

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.
Highlighted

I  suppose the bets bet is

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

Highlighted

I think above guys told you

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

No agent (yet)

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.

Highlighted

No need to export, you can

No need to export, you can also flush the data and snapshot.