[arch-dev-public] Mysql update

[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?

-- 

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