Re: [cobalt-users] Mysql Upgrade

["Sherwin T. Ang" <sherwin@xxxxxxxxxxxxxxx>]

Hello,

Jose Luis is right you can just dump your databases via mysqldump

mysqldump -uroot -p --all-databases -e --add-drop-table > dump.sql

in my experience, installing the new mysql binaries and copying the data
directory of mysql to the new one also works the same, well because there's
not much difference between the 3.23.x branch unlike with mysql 4.0.x
although upgrading from 3.23.x to 4.0.x works the same, one must do the
mysql_fix_privilege_tables to take advantage of the new privileges table of
mysql 4.

just remember to shutdown the mysql before copying the data directory to
close and read/writes/locks, after you copy it, change the owner of the new
data folder to the mysql user so that mysql will be able to read and write
to it.

Respectfully yours,

Sherwin T. Ang
Systems Administrator
Tridel Technologies Incorporated
Phone: (632) 6345140 Local 1024
Email: sherwin at tridel dot net
Web: http://www.tridel.net

----- Original Message -----
From: "José Luis Chafardet G." <joseluis@xxxxxxxxxxxxxxxx>
To: <cobalt-users@xxxxxxxxxxxxxxx>
Sent: Tuesday, February 25, 2003 9:10 AM
Subject: Re: [cobalt-users] Mysql Upgrade


> I'm really new to cobalt but you may try dumping the databases then
> upgrading the package, in pkgmaster.com is a package, i dunno if it
reweite
> or delete the databases, i did install the package after oppening to sale
> space.
>
> Best regards,
>
> José Luis Chafardet g
> ----- Original Message -----
> From: "Todd W" <twooly@xxxxxxxxx>
> To: <cobalt-users@xxxxxxxxxxxxxxx>
> Sent: Monday, February 24, 2003 8:08 PM
> Subject: [cobalt-users] Mysql Upgrade
>
>
> > I am currently running mysql version 3.23.37 and would like to upgrade
to
> > 3.23.54.  I currently have sites that are using their databases
therefore
> I
> > can't lose that data that is in these.  Can someone give me the best way
> to
> > get these upgraded.  I am running a Raq4 all patched up and Chilisoft
that
> > was orginally installed and I am using that asp.  One site in fact
> connects
> > to mysql through asp odbc driver 3.22.32.
> >
> > Thanks
> >
> > --Todd
> >
> > _____________________________________
> > cobalt-users mailing list
> > cobalt-users@xxxxxxxxxxxxxxx
> > To subscribe/unsubscribe, or to SEARCH THE ARCHIVES, go to:
> > http://list.cobalt.com/mailman/listinfo/cobalt-users
> >
> >
> >
>
>
> _____________________________________
> cobalt-users mailing list
> cobalt-users@xxxxxxxxxxxxxxx
> To subscribe/unsubscribe, or to SEARCH THE ARCHIVES, go to:
> http://list.cobalt.com/mailman/listinfo/cobalt-users
>
>