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?

Ward Vandewege wrote:
> Kristian Hermansen wrote:
>> Can you simply move 4.x /var/lib/ data to a 5.x installation and have
>> it work?
> Last time I did this (on Debian or Ubuntu), MySQL automatically upgraded the
> tables...

Right, but the trick is that you'd have to start by installing a 4.x 
version on the new machine, and then upgrade it. Otherwise I don't think 
it would pick up that the table format is obsolete and upgrade them on 
server startup. If you poke around, you can probably find the table 
upgrade scripts and run them manually, which would avoid needing to 
install the old version first.

But by the time you're done with those extra steps, it would probably 
have been faster to use mysqldump, unless the databases are huge.


Tom Metro
Venture Logic, Newton, MA, USA
"Enterprise solutions through open source."
Professional Profile:

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 /