Package: mysql-server-5.0 Version: 5.0.18-1 Followup-For: Bug #345895
This is a duplicate of #345895 but I can provide some more detail and hopefully a fix. After updating to mysql-server-5.0, my mysqld would not start due to the same error noted in #345895: Jan 4 14:14:15 tela mysqld[14638]: 060104 14:14:15 [ERROR] Fatal error: Can't open and lock privilege tables: Can't find file: 'host' (errno: 2) My server has been upgraded from 3.x to 4.x nad now 5.x. At least the "host" table in the "mysql" database was in ISAM format, which was supported by 4.1 but is not supported by 5.0 so the server failed to start. I was able to re-install an older mysql-server-4.1 package, run "mysql_convert_table_format mysql" with the old server running, and then re-install the 5.0 server. So I think the 5.0 server (or perhaps the 4.1 placeholder package) should ensure that all tables are in a compatible format before upgrading, perhaps running "mysql_convert_table_format" before removing the old 4.1 server. -- System Information: Debian Release: testing/unstable APT prefers unstable APT policy: (500, 'unstable') Architecture: i386 (i686) Shell: /bin/sh linked to /bin/bash Kernel: Linux 2.6.14.3 Locale: LANG=C, LC_CTYPE=C (charmap=ANSI_X3.4-1968) Versions of packages mysql-server-5.0 depends on: ii adduser 3.80 Add and remove users and groups ii debconf [debconf 1.4.67 Debian configuration management sy ii libc6 2.3.5-11 GNU C Library: Shared libraries an ii libdbi-perl 1.48-2 Perl5 database interface by Tim Bu ii libgcc1 1:4.0.2-5 GCC support library ii libmysqlclient15 5.0.18-1 mysql database client library ii libncurses5 5.5-1 Shared libraries for terminal hand ii libreadline5 5.1-5 GNU readline and history libraries ii libstdc++6 4.0.2-5 The GNU Standard C++ Library v3 ii libwrap0 7.6.dbs-8 Wietse Venema's TCP wrappers libra ii mailx 1:8.1.2-0.20050715cvs-1 A simple mail user agent ii mysql-client-5.0 5.0.18-1 mysql database client binaries ii mysql-common 5.0.18-1 mysql database common files (e.g. ii passwd 1:4.0.13-7 change and administer password and ii perl 5.8.7-10 Larry Wall's Practical Extraction ii psmisc 21.8-1 Utilities that use the proc filesy ii zlib1g 1:1.2.3-9 compression library - runtime mysql-server-5.0 recommends no packages. -- debconf information: mysql-server-5.0/really_downgrade: false mysql-server-5.0/start_on_boot: true mysql-server-5.0/nis_warning: mysql-server-5.0/postrm_remove_databases: false * mysql-server-5.0/mysql_install_db_notes: mysql-server-5.0/mysql_update_hints1: -- To UNSUBSCRIBE, email to [EMAIL PROTECTED] with a subject of "unsubscribe". Trouble? Contact [EMAIL PROTECTED]