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@jabber.archlinux.de WWW http://www.archlinux.de