[debian-mysql] Bug#491386: mysql-server-5.0: ERROR 1064 during mysql start after upgrade

[Ævar Arnfjörð Bjarmason]

Package: mysql-server-5.0
Version: 5.0.51a-6
Severity: normal


sh-3.2$ sudo /etc/init.d/mysql status
MySQL is stopped..
sh-3.2$ sudo /etc/init.d/mysql start
Starting MySQL database server: mysqld.
Checking for corrupt, not cleanly closed and upgrade needing tables..
sh-3.2$ ERROR 1064 (42000) at line 1: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '-albums' at line 1
ERROR 1064 (42000) at line 1: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '-comments' at line 1
ERROR 1064 (42000) at line 1: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '-images' at line 1
ERROR 1064 (42000) at line 1: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '-options' at line 1

sh-3.2$ ps aux|grep mysql
root     19921  0.0  0.1  92836  1368 pts/11   S    02:56   0:00 /bin/sh /usr/bin/mysqld_safe
mysql    19960  0.3  2.9 163900 30812 pts/11   Sl   02:56   0:00 /usr/sbin/mysqld --basedir=/usr --datadir=/var/lib/mysql --user=mysql --pid-file=/var/run/mysqld/mysqld.pid --skip-external-locking --port=3306 --socket=/var/run/mysqld/mysqld.sock
root     19961  0.0  0.0  87700   632 pts/11   S    02:56   0:00 logger -p daemon.err -t mysqld_safe -i -t mysqld
avar     20250  0.0  0.0  87820   720 pts/11   S+   02:57   0:00 grep mysql

-- System Information:
Debian Release: lenny/sid
  APT prefers testing
  APT policy: (500, 'testing')
Architecture: amd64 (x86_64)

Kernel: Linux 2.6.16.29-xen (SMP w/4 CPU cores)
Locale: LANG=en_US.UTF-8, LC_CTYPE=en_US.UTF-8 (charmap=UTF-8) (ignored: LC_ALL set to en_US.UTF-8)
Shell: /bin/sh linked to /bin/bash

Versions of packages mysql-server-5.0 depends on:
ii  adduser                3.108             add and remove users and groups
ii  debconf [debconf-2.0]  1.5.22            Debian configuration management sy
ii  libc6                  2.7-10            GNU C Library: Shared libraries
ii  libdbi-perl            1.605-1           Perl5 database interface by Tim Bu
ii  libgcc1                1:4.3.1-2         GCC support library
ii  libmysqlclient15off    5.0.51a-6         MySQL database client library
ii  libncurses5            5.6+20080308-1    Shared libraries for terminal hand
ii  libreadline5           5.2-3             GNU readline and history libraries
ii  libstdc++6             4.3.1-2           The GNU Standard C++ Library v3
ii  libwrap0               7.6.q-15          Wietse Venema's TCP wrappers libra
ii  lsb-base               3.2-12            Linux Standard Base 3.2 init scrip
ii  mysql-client-5.0       5.0.51a-6         MySQL database client binaries
ii  mysql-common           5.0.51a-6         MySQL database common files
ii  passwd                 1:4.1.1-2         change and administer password and
ii  perl                   5.10.0-11         Larry Wall's Practical Extraction 
ii  psmisc                 22.6-1            Utilities that use the proc filesy
ii  zlib1g                 1:1.2.3.3.dfsg-12 compression library - runtime

Versions of packages mysql-server-5.0 recommends:
ii  bsd-mailx [mailx]  8.1.2-0.20071201cvs-3 A simple mail user agent
ii  libhtml-template-p 2.9-1                 HTML::Template : A module for usin
ii  mailx              1:20071201-3          Transitional package for mailx ren

-- debconf information:
  mysql-server/root_password_again: (password omitted)
  mysql-server/root_password: (password omitted)
  mysql-server-5.0/really_downgrade: false
  mysql-server-5.0/need_sarge_compat: false
  mysql-server-5.0/start_on_boot: true
  mysql-server/error_setting_password:
  mysql-server-5.0/nis_warning:
  mysql-server-5.0/postrm_remove_databases: false
  mysql-server-5.0/need_sarge_compat_done: true
  mysql-server/password_mismatch: