[arch-dev-public] MySQL 5.5
angvp at archlinux.org
Sat Feb 5 10:13:42 EST 2011
2011/2/5 Pierre Schmitz <pierre at archlinux.de>:
> On Fri, 4 Feb 2011 18:22:08 -0200, Ángel Velásquez wrote:
>> 2011/2/4 Dan McGee <dpmcgee at gmail.com>:
>>> 2011/2/4 Ángel Velásquez <angvp at archlinux.org>:
>>>> As Dan's pointed just need a pacman -Syu && mysql-upgrade &&
>>>> /etc/rc.d/mysql restart , I've tried on two machines on production,
>>>> and my workstation for weeks and it's working just fine,
>>>> Maybe we can write a news about it (because some people usersread
>>>> .install messages :P)
>>> Don't you want to run upgrade after restart?
>> pacman -Syu && /etc/rc.d/mysqld restart && mysql-upgrade
> I don't think it's that easy as the restart could/will fail. You also
> need to adjust the my.cnf. I had some options in there that are no
> longer valid.
> Pierre Schmitz, https://users.archlinux.de/~pierre
Adding Pierre's Opinion
MySQL 5.5 is now in [extra]. This is a major version upgrade from the
5.1 editions previously in the repositories. Archive, Blackhole, and
Federated engine support are no longer included in this package, since
they are not heavily used.
After upgrading the MySQL package and restarting the database, you
will need to run `mysql_upgrade` to ensure your tables, views and
stored procedures are up to date and compatible with MySQL 5.5.
Is always good to do a backup of your databases, before doing the
update, you will also need to adjust my.cnf options in order to make
it compatible with 5.5 release, <a
info available here</a>
End of Draft
I've delayed the update until the draft is completely approved, but I
hope to do it today.
angvp @ irc.freenode.net
Arch Linux Developer / Trusted User
Linux Counter: #359909
More information about the arch-dev-public