> On Feb 26, 2020, at 4:51 PM, damjan jancic <[email protected]> wrote:
>
>
>
> Hello,
>
>
> We need to backup SQL server with more than 600 databases.
>
> according to bareos documentation for each database instance you need to
> define a exclusive backup job and fileset.
>
> Are there any options other than creating more than 600 backup jobs and
> filesets?
Is this one database instance with multiple ‘databases’ eg; mysql> use
database1; use database2; etc?
If it’s all on once host you can connect to the database server with multiple
databases your good. You would need one entry per host not database.
If it is you are able to use the plugins here:
https://docs.bareos.org/Appendix/Howtos.html#backup-of-a-mysql-database
I use the python plugin, it’s straggly slow but I like it better than my old
way. In my case I use a job like:
#
http://doc.bareos.org/master/html/bareos-manual-main-reference.html#x1-613000H.2.3
FileSet {
Name = "mlds-mysql"
Include {
Options {
signature = MD5
compression = GZIP6
}
Plugin =
"python:module_path=/usr/lib/bareos/plugins:module_name=bareos-fd-mysql:mysqlhost=mlds:mysqluser=root:mysqlpassword=<password>"
}
}
By not passing in a database name it just backups them all.
You can also use scripts to just invoke the dump command of your choice and
then make a fileset that backups the dumped files.
https://docs.bareos.org/Configuration/Director.html#config-Dir_Job_RunScript
The included bareos backup catalog job has an example of how to call an
external script and backup the dump for exactly that.
>
>
> Kind regards,
> Damjan
>
> --
> You received this message because you are subscribed to the Google Groups
> "bareos-users" group.
> To unsubscribe from this group and stop receiving emails from it, send an
> email to [email protected].
> To view this discussion on the web visit
> https://groups.google.com/d/msgid/bareos-users/c526ec73-60bc-498f-a66a-c1e83a31f9eb%40googlegroups.com.
--
You received this message because you are subscribed to the Google Groups
"bareos-users" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to [email protected].
To view this discussion on the web visit
https://groups.google.com/d/msgid/bareos-users/58F68394-93C4-46D6-8032-3DBBE5FFDBE5%40mlds-networks.com.
