[Bug 123427] Re: [apport] package mysql-server-5.0 failed to install/upgrade:

[Torsten Bronger]

Today, I found out that the very same root cause also prevents database
dump for backups from working:

> mysqldump --opt mysql > mysql.sql 
mysqldump: Couldn't execute '/*!40103 SET TIME_ZONE='+00:00' */': Table 'mysql.time_zone_name' doesn't exist (1146)

After re-installing mysql-server, it works again.  Thus, not only the
internal user table but also the timezone table is gone.  Maybe all
other internal tables, too.

Again: This makes backups via a database dump impossible.  Is this
really "Importance: Medium"?


By the way, the only maintainer question for making this "incomplete" bug complete for almost one year was, "Do you have any files in /var/lib/mysql/?"  Of course I have: There is my database after all!  Look, I'm really willing to help with this but please do it seriously.

Or, declare that until further notice MySQL Server doesn't work on
Ubuntu and that you recommend PostgreSQL.

-- 
[apport] package mysql-server-5.0 failed to install/upgrade: 
https://bugs.launchpad.net/bugs/123427
You received this bug notification because you are a member of Ubuntu
Server Team, which is subscribed to mysql-dfsg-5.0 in ubuntu.