Upgrading MySQL Without Wrecking Bacula
Kevin Kinsey
kdk at daleco.biz
Sat Jun 11 05:26:43 GMT 2005
Drew Tomlinson wrote:
> I am a total noob regarding MySQL. I have version 3.23 installed on
> my 4.10 system. The only thing it's been used for and by is Bacula.
> I have never used it directly.
>
> But now I have reason to learn MySQL and feel it would be appropriate
> to start with a newer version. I see there's 4.1 and 5.0. Even
> though it's beta, I'm inclined to just start with 5.0 since my data
> will not be super critical and quite small. Basically I want t make a
> product database and display it via web pages. There are less than
> 10,000 products. I also don't see more than 2 or 3 clients accessing
> it at one time. Maybe in an extreme case there might be 10 clients.
> Overall, pretty small.
>
> So what must I do to upgrade from 3.23 to something newer and keep
> Bacula happy. I've read the Bacula web site and it claims to work
> with 3.23 and higher. I've browsed the MySQL site and see
> instructions to upgrade from 3.23 to 4.0, 4.0 to 4.1, and upgrading to
> 5.0. However I'm sure I don't really need to upgrade in steps?
>
> Any guidance, advice, and/or links to tutorials would be greatly
> appreciated.
>
> Thanks,
>
> Drew
>
I like mysqldump for easy to recreate backups:
$ mysqldump sometable > sometable.sql
To restore, you need to add a statement to the top
of the file, like "use sometable". Then:
$ mysqladmin create cometable
and, finally:
$mysql < sometable.sql
And everything should be "good to go".
Sorry I'm not much more help. I use portupgrade and/or portmanager
to keep things somewhat "up to date", but I don't know if there would
be any "gotchas" with that and Bacula or not. I'd tend to think that as
long as I had all my databases backed up, I could uninstall 323 and
install something from the 4X or 5X line and not have too many issues.
You might want to learn a little about using the MySQL monitor itself,
first, in 3.23; a little knowledge of MySQL syntax would add to your
confidence in restoring the data, I would think . . .
HTH,
Kevin Kinsey
More information about the freebsd-questions
mailing list