Skip site navigation (1)Skip section navigation (2)
Date:      Thu, 29 May 2003 18:14:56 -0700
From:      BSD baby <bsdlap@hitmedia.com>
To:        Olivier Nicole <on@cs.ait.ac.th>
Cc:        freebsd-questions@freebsd.org
Subject:   Re: Mysql
Message-ID:  <20030530011456.GA39366@mail.hitmedia.com>
In-Reply-To: <200305300040.HAA10310@banyan.cs.ait.ac.th>
References:  <PPECLBJKHADMJKGPJMEFCEBDCKAA.ian@cerebellum.za.net> <200305300040.HAA10310@banyan.cs.ait.ac.th>

next in thread | previous in thread | raw e-mail | index | archive | help
> > I want to remove my mysql installation and re-install from scratch. Now the
> > problem. I have 6 active databases. How can i make sure that i dont loose
> > those. And that when i have re-installed, that they work immediatilly ??
> 
> I'd think mysql dump and restore would be the safest way and would
> allow some porting between different verions of MySQL.


Good point.  The mysqldump command you probably want is:

mysqldump -u YourUserName -p -A > alldb.mysql

That should dump all databases.



Want to link to this message? Use this URL: <https://mail-archive.FreeBSD.org/cgi/mid.cgi?20030530011456.GA39366>