Dear Brock,
It is the backup of MS SQL server databases(not mysql).
When I remove database name from the file set I got an error:
"Fatal error: An object or column name is missing or empty. For SELECT INTO
statements, verify each column has a name. For other statements, look for
empty alias names. Aliases defined as "" or [] are not allowed. Change the
alias to a valid name"
When I remove all part databases=<$databsename> I got an error:
"Fatal error: An object or column name is missing or empty. For SELECT INTO
statements, verify each column has a name. For other statements, look for
empty alias names. Aliases defined as "" or [] are not allowed. Change the
alias to a valid name."
File set:
Fileset {
Name = "testowt-sql-fileset"
Enable VSS = No
Include {
Options {
Signature = MD5
compression = gzip
}
Plugin =
"mssqlvdi:instance=default:database=testowt:username=btest:password=**********"
}
}
Kind regards,
Damjan
On Wednesday, February 26, 2020 at 11:05:06 PM UTC+1, Brock Palen wrote:
>
>
>
> > On Feb 26, 2020, at 4:51 PM, damjan jancic <[email protected]
> <javascript:>> 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] <javascript:>.
> > 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/7cf137fc-cd21-4e01-98ae-bfbe5d1b8e9c%40googlegroups.com.
