Bug #13050 mysqldump: Can't get CREATE TABLE for table `help_category` (File '/usr/share/m
Submitted: 7 Sep 2005 20:42 Modified: 8 Sep 2005 13:44
Reporter: Gerd Aschemann Email Updates:
Status: Not a Bug Impact on me:
None 
Category:MySQL Server Severity:S1 (Critical)
Version:4.0.24_Debian-10-log OS:Linux (Debian 3.1 (sarge))
Assigned to: CPU Architecture:Any

[7 Sep 2005 20:42] Gerd Aschemann
Description:
When trying to dump the mysql database mysqldump I get the error above.

How to repeat:
mysqldump -u root -p mysql
[7 Sep 2005 20:43] Gerd Aschemann
Complete Error message is

mysqldump: Can't get CREATE TABLE for table `help_category` (File '/usr/share/mysql/charsets/?.conf' not found (Errcode: 2))
[7 Sep 2005 22:23] Hartmut Holzgraefe
help_category is a 4.1 system table, its not part of 4.0 installations (until Debian does something
completely different here). Have you performed a downgrade that left the 4.1 table around or
something like that?
[8 Sep 2005 5:36] Gerd Aschemann
Yes we have downgraded to 4.0. How can I cope with the problem? Can I just drop the tables?

Do I have to drop these four: help_category, help_keyword, help_topic,  time_zone_name?
[8 Sep 2005 13:44] Hartmut Holzgraefe
http://dev.mysql.com/doc/mysql/en/option-files.html
[27 Sep 2005 7:42] Gerd Aschemann
OK, what will the options file provide as help to my problem?