From owner-freebsd-questions@FreeBSD.ORG Fri Jun 10 20:48:11 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 5481316A41C for ; Fri, 10 Jun 2005 20:48:11 +0000 (GMT) (envelope-from drew@mykitchentable.net) Received: from relay01.roc.ny.frontiernet.net (relay01.roc.ny.frontiernet.net [66.133.182.164]) by mx1.FreeBSD.org (Postfix) with ESMTP id F419A43D1F for ; Fri, 10 Jun 2005 20:48:10 +0000 (GMT) (envelope-from drew@mykitchentable.net) Received: from filter01.roc.ny.frontiernet.net (filter01.roc.ny.frontiernet.net [66.133.183.68]) by relay01.roc.ny.frontiernet.net (Postfix) with ESMTP id 372563641BC for ; Fri, 10 Jun 2005 20:48:10 +0000 (UTC) Received: from relay01.roc.ny.frontiernet.net ([66.133.182.164]) by filter01.roc.ny.frontiernet.net (filter01.roc.ny.frontiernet.net [66.133.183.68]) (amavisd-new, port 10024) with LMTP id 18952-07-75 for ; Fri, 10 Jun 2005 20:48:10 +0000 (UTC) Received: from blacklamb.mykitchentable.net (70-97-204-86.dsl2.elk.ca.frontiernet.net [70.97.204.86]) by relay01.roc.ny.frontiernet.net (Postfix) with ESMTP id E34D236416E for ; Fri, 10 Jun 2005 20:48:07 +0000 (UTC) Received: from [165.107.42.217] (unknown [165.107.42.217]) (using TLSv1 with cipher DHE-RSA-AES256-SHA (256/256 bits)) (No client certificate requested) by blacklamb.mykitchentable.net (Postfix) with ESMTP id 47D743BF3B9 for ; Fri, 10 Jun 2005 13:47:58 -0700 (PDT) Message-ID: <42A9FC36.8@mykitchentable.net> Date: Fri, 10 Jun 2005 13:46:46 -0700 From: Drew Tomlinson User-Agent: Mozilla Thunderbird 1.0 (Windows/20041206) X-Accept-Language: en-us, en MIME-Version: 1.0 To: FreeBSD Questions Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Scanned: by amavisd-new-20040701 (2.0) at filter01.roc.ny.frontiernet.net Subject: 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: Fri, 10 Jun 2005 20:48:11 -0000 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 -- Visit The Alchemist's Warehouse Magic Tricks, DVDs, Videos, Books, & More! http://www.alchemistswarehouse.com