From owner-freebsd-questions@FreeBSD.ORG Sat Jun 11 17:05:56 2005 Return-Path: X-Original-To: freebsd-questions@freebsd.org Delivered-To: freebsd-questions@freebsd.org Received: from mx1.FreeBSD.org (mx1.freebsd.org [216.136.204.125]) by hub.freebsd.org (Postfix) with ESMTP id 0745016A41C for ; Sat, 11 Jun 2005 17:05:56 +0000 (GMT) (envelope-from drew@mykitchentable.net) Received: from relay04.roc.ny.frontiernet.net (relay04.roc.ny.frontiernet.net [66.133.182.167]) by mx1.FreeBSD.org (Postfix) with ESMTP id 2EFC343D55 for ; Sat, 11 Jun 2005 17:05:55 +0000 (GMT) (envelope-from drew@mykitchentable.net) Received: from filter08.roc.ny.frontiernet.net (filter08.roc.ny.frontiernet.net [66.133.183.75]) by relay04.roc.ny.frontiernet.net (Postfix) with ESMTP id 687DE3580A3; Sat, 11 Jun 2005 17:05:54 +0000 (UTC) Received: from relay04.roc.ny.frontiernet.net ([66.133.182.167]) by filter08.roc.ny.frontiernet.net (filter08.roc.ny.frontiernet.net [66.133.183.75]) (amavisd-new, port 10024) with LMTP id 28771-16-4; Sat, 11 Jun 2005 17:05:54 +0000 (UTC) Received: from blacklamb.mykitchentable.net (70-97-204-86.dsl2.elk.ca.frontiernet.net [70.97.204.86]) by relay04.roc.ny.frontiernet.net (Postfix) with ESMTP id 47C33358056; Sat, 11 Jun 2005 17:05:36 +0000 (UTC) Received: from [192.168.1.25] (lugalong.mykitchentable.net [192.168.1.25]) (using TLSv1 with cipher DHE-RSA-AES256-SHA (256/256 bits)) (No client certificate requested) by blacklamb.mykitchentable.net (Postfix) with ESMTP id 5F60F3BF3CE; Sat, 11 Jun 2005 10:05:35 -0700 (PDT) Message-ID: <42AB19DE.1030306@mykitchentable.net> Date: Sat, 11 Jun 2005 10:05:34 -0700 From: Drew Tomlinson User-Agent: Mozilla Thunderbird 1.0 (Windows/20041206) X-Accept-Language: en-us, en MIME-Version: 1.0 To: Kevin Kinsey References: <42A9FC36.8@mykitchentable.net> <42AA75BF.6090509@daleco.biz> In-Reply-To: <42AA75BF.6090509@daleco.biz> Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Scanned: by amavisd-new-20040701 (2.0) at filter08.roc.ny.frontiernet.net Cc: FreeBSD Questions Subject: Re: Upgrading MySQL Without Wrecking Bacula X-BeenThere: freebsd-questions@freebsd.org X-Mailman-Version: 2.1.5 Precedence: list List-Id: User questions List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , X-List-Received-Date: Sat, 11 Jun 2005 17:05:56 -0000 On 6/10/2005 10:25 PM Kevin Kinsey wrote: > 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". Thanks for the tip. It gives me somewhere to start. > 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. Me too. portupgrade is a great tool. I agree that if I have the databases backed up, I should be able to restore. This is just my home system so if the worst happened and I lost my complete bacula database, it still wouldn't be the end of the world (unless my hard drive crashed before I got bacula running again). > 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 . . . I've fiddled around with MySQL a little so far. Webmin provides an easy interface to administering MySQL users, databases, etc. and that has been very helpful. Now I just have to learn what "real" commands Webmin calls when performing these functions. I suspect it uses mysqladmin. Thanks for your reply, Drew -- Visit The Alchemist's Warehouse Magic Tricks, DVDs, Videos, Books, & More! http://www.alchemistswarehouse.com