On Wednesday 22 of December 2010 08:33:20 Andrea Scarpino wrote:

On Tuesday 21 December 2010 16:16:57 Andrea Scarpino wrote:

...

I am trying to update mysql to 5.5.8. It uses cmake now.

I built and successfully installed it on my system. It seems to work, but I won't broke any Arch Linux system and I want to know the right procedure on how to proceed with this major update. Also, before I put the packages in [testing], I'd like if someone can take a look to them or try the new packages.

PKGBUILD is here[1]; packages are here[2]. A diff between my PKGBUILD and the current one is here[3].

Remember that you need to run mysql_upgrade as root after the installation and with mysql running. I added a message to post_update() for this.

No reply. This goes in [testing] to get more feedback.

You were right :) ==> Software upgrade (new version) : testing/libmysqlclient 5.1.51-1 -> 5.5.8-1 testing/mysql-clients 5.1.51-1 -> 5.5.8-1 testing/mysql 5.1.51-1 -> 5.5.8-1 ==> Continue upgrade ? [Y/n] ==> [V]iew package detail [M]anually select packages ==> -------------------------------------------------- ==> :: Starting full system upgrade... resolving dependencies... looking for inter-conflicts... Targets (3): libmysqlclient-5.5.8-1 [3.38 MB] mysql-clients-5.5.8-1 [0.68 MB] mysql-5.5.8-1 [6.20 MB] Total Download Size: 10.26 MB Total Installed Size: 103.15 MB Proceed with installation? [Y/n] :: Retrieving packages from testing... libmysqlclient-5.5.8-1-i686 3.4M 150.8K/s 00:00:23 [#####################################] 100% mysql-clients-5.5.8-1-i686 694.4K 52.0K/s 00:00:13 [#####################################] 100% mysql-5.5.8-1-i686 6.2M 142.8K/s 00:00:44 [#####################################] 100% checking package integrity... (3/3) checking for file conflicts [#####################################] 100% (1/3) upgrading libmysqlclient [#####################################] 100% (2/3) upgrading mysql-clients [#####################################] 100% (3/3) upgrading mysql [#####################################] 100% warning: directory permissions differ on var/lib/mysql/ filesystem: 755 package: 700 Major version update. Consider running mysql_upgrade. [root@beruska ~]# mysql_upgrade Looking for 'mysql' as: mysql Looking for 'mysqlcheck' as: mysqlcheck Running 'mysqlcheck' with connection arguments: '--port=3306' '-- socket=/var/run/mysqld/mysqld.sock' '--port=3306' '-- socket=/var/run/mysqld/mysqld.sock' mysqlcheck: Got error: 2002: Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2) when trying to connect FATAL ERROR: Upgrade failed Any ideas? Thanks, Marek -- Marek Otahal :o)