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?



Tom Metro wrote:
> 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
> 
The tables aren't all that big; just a PITA to try to recreate.  I did 
the dump/import and that seems to have worked.  Of course now I'm in php 
hell (output_buffering refuses to be set properly, Gallery2 installation 
doesn't recognise directory permissions) so it'll be a fun weekend.

Thanks for the help!
  -Don

-- 
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 / webmaster@blu.org