10-24-2010 11:02 AM
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.
Solved! Go to Solution.
10-24-2010 11:53 AM
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.
10-24-2010 11:53 AM
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.
10-25-2010 03:26 AM
10-25-2010 04:30 AM
I suppose the bets bet is make a dump and grab it to a tape as a plain file.
10-25-2010 04:39 AM
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
10-25-2010 09:00 AM
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.
10-26-2010 02:40 AM