Backing up Mysql on Version 9.1

[ryanropp]

I'm new to veritas and mysql. I know in arcserve you have to have the sql agent installed to backup a full sql database. I have selected the data folder to be backed up but noticed that none of the .mdb files are getting backed up. I'm assuming this is because the mysql service is started and the files are showing as being shared. Is there an easy way to get around this without having to purchase the sql agent?

Thanks,
Ryan

 

[steveot]

You have a couple option:

First the Veritas SQL agent will not backup MySQL.

If you want to back the files up directly you must make the following registry change on the Backup Exec server:

http://seer.support.veritas.com/docs/259152.htm

Once you make this change you should be able to backup the files but if the MYsql is running Im sure you will see them skipped in the job log.
You can create batch files to stop/start the mysql and place the batch files in the pre/post command in the Backup Job setup. Then it may grab them. Otherwise you will still need to make the registry change above and purchase the AOFO option.

http://support.veritas.com/docs/263784

 

[LawnBoy]

Or, you can cause MySQL to create it's own backups, then use BE to copy them to archive. I do this with MSSQL and Oracle, works great for our situation.

 

[ryanropp]

I just used microsoft backup in server 2003 to backup the files to a folder before veritas runs and have veritas get that folder, works great