Re: [cobalt-users] MySQL Update

["Andy Clyde, oxfordmusic.net" <andy.clyde@xxxxxxxxxxxxxxx>]

>
> > > Hi All,
> > >
> > > How do I go about updating MySQL on the RAQ4 without loosing all the
> > > databases already created?
> > >
>
> > Install the newer version of MySQL to a different directory, then
> > copy /var/mysql (or wherever) the data files are on top of the new ones'
> data
> >
>
> Hi Roland.
>
> Thanks for that, but if i install the MySQL pkg wont it overwrite the
> databases? If so how would I back them up from the command line without
> having to do a dump of each database. i.e. move the files somewhere, then
> update then move them back.
>
> Would this work

you can try using mysqlhotcopy. that creates a text file with all the
commands to recreate all your data.

there's a good help file you can download:
http://www.mysql.com/documentation/mysql/alternate.html

andy