[arch-dev-public] Mysql update

[Pierre Schmitz]

Am Mittwoch, 25. März 2009 15:36:30 schrieb Pierre Schmitz:
> Am Dienstag, 24. März 2009 12:28:25 schrieb Douglas Soares de Andrade:
> > Hi guys,
> >
> > Finnaly i took some time and updated mysql to testing. I did almost all
> > the needed rebuilds - i did not rebuilt dovecot as it needs the new
> > libpcap, can someone build it for me ? - Im also uploading
> > mysql-gui-tools 5.0r14 for my public page.
> >
> > Thanks all =)
>
> Does anybody know how to upgrade to this new server? When trying to start
> it it fails with the following log entries:
>
> 090325 15:27:28 mysqld_safe Starting mysqld daemon with databases from
> /var/lib/mysql
> 090325 15:27:28 [Warning] The syntax '--log_slow_queries' is deprecated and
> will be removed in MySQL 7.0. Please use '--slow_query_log'/'--
> slow_query_log_file' instead.
> /usr/sbin/mysqld: Table 'mysql.plugin' doesn't exist
> 090325 15:27:28 [ERROR] Can't open the mysql.plugin table. Please run
> mysql_upgrade to create it.
> 090325 15:27:28 [ERROR] /usr/sbin/mysqld: unknown option '--skip-innodb'
> 090325 15:27:28 [ERROR] Aborting
>
> 090325 15:27:28 [Note] /usr/sbin/mysqld: Shutdown complete
>
> 090325 15:27:28 mysqld_safe mysqld from pid file /var/lib/mysql/opteron.pid
> ended
>
>
> So, I tried
>
> sudo mysql_upgrade
> Looking for 'mysql' as: mysql
> Looking for 'mysqlcheck' as: mysqlcheck
> Running 'mysqlcheck'...
> mysqlcheck: Got error: 2002: Can't connect to local MySQL server through
> socket '/tmp/mysql.sock' (2) when trying to connect
> FATAL ERROR: Upgrade failed
>
>
> Does this mean I cannot start mysql until I had run mysql_upgrade? And
> mysql_upgrade does only work when the server is running?

Well, after removing the following config entries I was able to start mysqld 
and run mysql_upgrade. 

#skip-innodb
#skip-bdb
#skip-federated

However: I think we'll need some kind of upgrade guide. Especially intersting 
would be the names of the new config parameters and how to run mysql_upgrade.

-- 

Pierre Schmitz


Clemens-August-Straße 76
53115 Bonn

Telefon		0228 9716608
Mobil		0160 95269831
Jabber		pierre at jabber.archlinux.de
WWW		http://www.archlinux.de