From owner-freebsd-questions@FreeBSD.ORG Sat Jun 11 05:26:43 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 67BC816A41C for ; Sat, 11 Jun 2005 05:26:43 +0000 (GMT) (envelope-from kdk@daleco.biz) Received: from ezekiel.daleco.biz (southernuniform.com [66.76.92.18]) by mx1.FreeBSD.org (Postfix) with ESMTP id 0DDBC43D49 for ; Sat, 11 Jun 2005 05:26:42 +0000 (GMT) (envelope-from kdk@daleco.biz) Received: from [192.168.2.2] ([69.27.157.226]) by ezekiel.daleco.biz (8.13.1/8.13.1) with ESMTP id j5B5QMOM073365; Sat, 11 Jun 2005 00:26:26 -0500 (CDT) (envelope-from kdk@daleco.biz) Message-ID: <42AA75BF.6090509@daleco.biz> Date: Sat, 11 Jun 2005 00:25:19 -0500 From: Kevin Kinsey User-Agent: Mozilla/5.0 (X11; U; FreeBSD i386; en-US; rv:1.7.8) Gecko/20050607 X-Accept-Language: en-us, en MIME-Version: 1.0 To: Drew Tomlinson References: <42A9FC36.8@mykitchentable.net> In-Reply-To: <42A9FC36.8@mykitchentable.net> Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit 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 05:26:43 -0000 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