[arch-general] [arch-dev-public] MySQL 5.5

[Marek Otahal]

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 at 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)
-------------- next part --------------
A non-text attachment was scrubbed...
Name: signature.asc
Type: application/pgp-signature
Size: 836 bytes
Desc: This is a digitally signed message part.
URL: <http://mailman.archlinux.org/pipermail/arch-general/attachments/20101222/b4c168d0/attachment.asc>