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 [email protected] WWW http://www.archlinux.de
