Boston Linux & Unix (BLU) Home | Calendar | Mail Lists | List Archives | Desktop SIG | Hardware Hacking SIG
Wiki | Flickr | PicasaWeb | Video | Maps & Directions | Installfests | Keysignings
Linux Cafe | Meeting Notes | Blog | Linux Links | Bling | About BLU

BLU Discuss list archive

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Moving a MySQL installation?

On Fri, Apr 13, 2007 at 08:31:52PM -0400, Kristian Hermansen wrote:
> On 4/13/07, Matt Shields <mattboston at> wrote:
> >Actually, option 1 is the preferred way to move the data.  That the
> >indexes do not have to be rebuilt.  Doing a dump and import it will
> >have to rebuild.
> Can you simply move 4.x /var/lib/ data to a 5.x installation and have
> it work?  I was under the impression that this data would not be
> suitable for a 5.x installation...

Last time I did this (on Debian or Ubuntu), MySQL automatically upgraded the
tables... I've had zero problems with this approach in the past, and use it


--         -( "Fools ignore complexity.  Pragmatists suffer it. Some  )-
Virtual hosting -(     can avoid it.  Geniuses remove it." -- Perlis's     )-  -(  Programming Proverb #58, SIGPLAN Notices, Sept.  1982  )-
GnuPG public key:

This message has been scanned for viruses and
dangerous content by MailScanner, and is
believed to be clean.

BLU is a member of BostonUserGroups
BLU is a member of BostonUserGroups
We also thank MIT for the use of their facilities.

Valid HTML 4.01! Valid CSS!

Boston Linux & Unix /