Discussion:
[bareos-users] Advice needed on how to switch Bareos database system
Markus
2018-07-26 14:52:28 UTC
Permalink
Hello,

I am running Bareos on a Linux Mint 18 server. The installation is using
sqlite for the database. Since I am going to need mySql on that server
anyway, I would like to 'convert' my existing Bareos installation from
using sqlite to using mySql. Does anybody have a pointer to some
documentation or HowTo on this is done?

Sorry if this question has been asked before but Google did not really
produce useful search results.

Thank You,
Markus.
--
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 bareos-users+***@googlegroups.com.
To post to this group, send email to bareos-***@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.
Markus
2018-07-27 14:23:36 UTC
Permalink
More specific question: I know how to make a catalog backup using
make_catalog_backup. Is this backup "portable", i.e. can I make a backup
of my current sqlite3 system, reconfigure Bareos to use mySql and then
restore that backup into mySql?
Post by Markus
Hello,
I am running Bareos on a Linux Mint 18 server. The installation is
using sqlite for the database. Since I am going to need mySql on that
server anyway, I would like to 'convert' my existing Bareos
installation from using sqlite to using mySql. Does anybody have a
pointer to some documentation or HowTo on this is done?
Sorry if this question has been asked before but Google did not really
produce useful search results.
Thank You,
Markus.
--
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 bareos-users+***@googlegroups.com.
To post to this group, send email to bareos-***@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.
Bruno Friedmann
2018-07-27 19:42:17 UTC
Permalink
Post by Markus
More specific question: I know how to make a catalog backup using
make_catalog_backup. Is this backup "portable", i.e. can I make a backup
of my current sqlite3 system, reconfigure Bareos to use mySql and then
restore that backup into mySql?
Post by Markus
Hello,
I am running Bareos on a Linux Mint 18 server. The installation is
using sqlite for the database. Since I am going to need mySql on that
server anyway, I would like to 'convert' my existing Bareos
installation from using sqlite to using mySql. Does anybody have a
pointer to some documentation or HowTo on this is done?
Sorry if this question has been asked before but Google did not really
produce useful search results.
Thank You,
Markus.
Unfortunately no, the make_catalog_backup is able to handle several database
engine, but the restore has to be with the same engine.
Each database has its own dialect.
--
Bruno Friedmann
Ioda-Net Sàrl www.ioda-net.ch
Bareos Partner, openSUSE Member, fsfe fellowship
GPG KEY : D5C9B751C4653227
irc: tigerfoot

openSUSE Tumbleweed
Linux 4.16.9-1-default x86_64 GNU/Linux, nvidia: 390.59
Qt: 5.10.0, KDE Frameworks: 5.46.0, Plasma: 5.12.5, kmail2 5.8.1
--
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 bareos-users+***@googlegroups.com.
To post to this group, send email to bareos-***@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.
Markus
2018-07-31 15:41:59 UTC
Permalink
Ok, so the database dump is not portable across sql engines. So I guess
there's no way to transfer the catalog except using a script which would
"translate" the database backup. I don't think I want to go that route
and try to make sure everything has been translated correctly.
What if I go ahead and reconfigure Bareos to use mySql and then recreate
the catalog the hard way using bscan. I never used bscan so my question
is: would that also restore media pool and volume retention information
besides the contents records? Or in other words: what kind of
information do I have to enter manually if I recreate the catalog
through bscan?

Thank You,
Markus.
Post by Bruno Friedmann
Post by Markus
More specific question: I know how to make a catalog backup using
make_catalog_backup. Is this backup "portable", i.e. can I make a backup
of my current sqlite3 system, reconfigure Bareos to use mySql and then
restore that backup into mySql?
Post by Markus
Hello,
I am running Bareos on a Linux Mint 18 server. The installation is
using sqlite for the database. Since I am going to need mySql on that
server anyway, I would like to 'convert' my existing Bareos
installation from using sqlite to using mySql. Does anybody have a
pointer to some documentation or HowTo on this is done?
Sorry if this question has been asked before but Google did not really
produce useful search results.
Thank You,
Markus.
Unfortunately no, the make_catalog_backup is able to handle several database
engine, but the restore has to be with the same engine.
Each database has its own dialect.
--
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 bareos-users+***@googlegroups.com.
To post to this group, send email to bareos-***@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.
Bruno Friedmann
2018-08-02 06:09:53 UTC
Permalink
Using bscan is one of the way, I recommend to read the disaster chapter of the documentation which explain how to restore a director.
With the empty configuration the needed informations (pools device etc with their attributes will be recreated, and bscan will fill up the db with the content of the media).
Beware it's normally a quite long process.
Post by Markus
Ok, so the database dump is not portable across sql engines. So I guess
there's no way to transfer the catalog except using a script which would
"translate" the database backup. I don't think I want to go that route
and try to make sure everything has been translated correctly.
What if I go ahead and reconfigure Bareos to use mySql and then
recreate
the catalog the hard way using bscan. I never used bscan so my question
is: would that also restore media pool and volume retention information
besides the contents records? Or in other words: what kind of
information do I have to enter manually if I recreate the catalog
through bscan?
Thank You,
Markus.
Post by Bruno Friedmann
Post by Markus
More specific question: I know how to make a catalog backup using
make_catalog_backup. Is this backup "portable", i.e. can I make a
backup
Post by Bruno Friedmann
Post by Markus
of my current sqlite3 system, reconfigure Bareos to use mySql and
then
Post by Bruno Friedmann
Post by Markus
restore that backup into mySql?
Post by Markus
Hello,
I am running Bareos on a Linux Mint 18 server. The installation is
using sqlite for the database. Since I am going to need mySql on
that
Post by Bruno Friedmann
Post by Markus
Post by Markus
server anyway, I would like to 'convert' my existing Bareos
installation from using sqlite to using mySql. Does anybody have a
pointer to some documentation or HowTo on this is done?
Sorry if this question has been asked before but Google did not
really
Post by Bruno Friedmann
Post by Markus
Post by Markus
produce useful search results.
Thank You,
Markus.
Unfortunately no, the make_catalog_backup is able to handle several
database
Post by Bruno Friedmann
engine, but the restore has to be with the same engine.
Each database has its own dialect.
--
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
For more options, visit https://groups.google.com/d/optout.
--
Sent from my Android device with K-9 Mail. Please excuse my brevity.
--
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 bareos-users+***@googlegroups.com.
To post to this group, send email to bareos-***@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.
Bruno Friedmann
2018-07-27 19:34:13 UTC
Permalink
Post by Markus
Hello,
I am running Bareos on a Linux Mint 18 server. The installation is using
sqlite for the database. Since I am going to need mySql on that server
anyway, I would like to 'convert' my existing Bareos installation from
using sqlite to using mySql. Does anybody have a pointer to some
documentation or HowTo on this is done?
Sorry if this question has been asked before but Google did not really
produce useful search results.
Thank You,
Markus.
Hi Markus, well I would said it will depend of the size of your db.

I would setup the new database (sorry I would tend for PostgreSQL ;-)
and use a tool like dbeaver, it can connect to both db, and has the ability
to move data (with conversion if needed) from one database to the other.
it's a table by table job, but bareos doesn't have too much.

Install the bareos-database-mysql package and setup mysql bareos instance with
the tools given.
--
Bruno Friedmann
Ioda-Net Sàrl www.ioda-net.ch
Bareos Partner, openSUSE Member, fsfe fellowship
GPG KEY : D5C9B751C4653227
irc: tigerfoot

openSUSE Tumbleweed
Linux 4.16.9-1-default x86_64 GNU/Linux, nvidia: 390.59
Qt: 5.10.0, KDE Frameworks: 5.46.0, Plasma: 5.12.5, kmail2 5.8.1
--
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 bareos-users+***@googlegroups.com.
To post to this group, send email to bareos-***@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.
Loading...