MySQL 1146

[Syoss]

Hallo,

es sah alles gut aus nach einer Neuinstallation von MySQL. Doch will ich nun via Navicat auf MySQL connecetn und wähle eine bestimme Tabelle aus bekomme ich den Error 1146.
Komisch die Tabellen bzw. Datenbanken existieren in /var/lib/mysql. Ein mysqlrepair geht ebenfalls nicht

Weiß wer Rat

[Cae]

Meine Glaskugel sagt, dass vielleicht eine erwartete Tabelle fehlt [1].

Gruß Cae

[1] http://dev.mysql.com/doc/refman/5.1/en/mysql-errno.html | http://dev.mysql.com/doc/refman/5.1/de/ ... erver.html

[Syoss]

Danke für deine Antwort. Ich denke das muss an InnoDB liegen.

a) Tabellen die vorher InnoDB waren und Dateiendung .frm haben nur komischerweise die MyISAM Engine.
b) Manuelles Ändern auf InnoDB bringt auch nur wieder fehler

Code: Alles auswählen

Oct 20 20:12:54 zulu1151 mysqld_safe[19070]: 111020 20:12:54 [Note] Plugin 'FEDERATED' is disabled.
Oct 20 20:12:54 zulu1151 mysqld_safe[19070]: InnoDB: The first specified data file ./ibdata1 did not exist:
Oct 20 20:12:54 zulu1151 mysqld_safe[19070]: InnoDB: a new database to be created!
Oct 20 20:12:54 zulu1151 mysqld_safe[19070]: 111020 20:12:54  InnoDB: Setting file ./ibdata1 size to 10 MB
Oct 20 20:12:54 zulu1151 mysqld_safe[19070]: InnoDB: Database physically writes the file full: wait...
Oct 20 20:12:54 zulu1151 mysqld_safe[19070]: 111020 20:12:54  InnoDB: Log file ./ib_logfile0 did not exist: new to be created
Oct 20 20:12:54 zulu1151 mysqld_safe[19070]: InnoDB: Setting log file ./ib_logfile0 size to 5 MB
Oct 20 20:12:54 zulu1151 mysqld_safe[19070]: InnoDB: Database physically writes the file full: wait...
Oct 20 20:12:54 zulu1151 mysqld_safe[19070]: 111020 20:12:54  InnoDB: Log file ./ib_logfile1 did not exist: new to be created
Oct 20 20:12:54 zulu1151 mysqld_safe[19070]: InnoDB: Setting log file ./ib_logfile1 size to 5 MB
Oct 20 20:12:54 zulu1151 mysqld_safe[19070]: InnoDB: Database physically writes the file full: wait...
Oct 20 20:12:54 zulu1151 mysqld_safe[19070]: InnoDB: Doublewrite buffer not found: creating new
Oct 20 20:12:54 zulu1151 mysqld_safe[19070]: InnoDB: Doublewrite buffer created
Oct 20 20:12:54 zulu1151 mysqld_safe[19070]: InnoDB: Creating foreign key constraint system tables
Oct 20 20:12:54 zulu1151 mysqld_safe[19070]: InnoDB: Foreign key constraint system tables created
Oct 20 20:12:54 zulu1151 mysqld_safe[19070]: 111020 20:12:54  InnoDB: Started; log sequence number 0 0
Oct 20 20:12:54 zulu1151 mysqld_safe[19070]: 111020 20:12:54 [ERROR] /usr/sbin/mysqld: Can't find file: './mysql/user.frm' (errno: 13)
Oct 20 20:12:54 zulu1151 mysqld_safe[19070]: ERROR: 1017  Can't find file: './mysql/user.frm' (errno: 13)
Oct 20 20:12:54 zulu1151 mysqld_safe[19070]: 111020 20:12:54 [ERROR] Aborting
Oct 20 20:12:54 zulu1151 mysqld_safe[19070]: 111020 20:12:54  InnoDB: Starting shutdown...
Oct 20 20:12:59 zulu1151 mysqld_safe[19070]: 111020 20:12:59  InnoDB: Shutdown completed; log sequence number 0 44233
Oct 20 20:12:59 zulu1151 mysqld_safe[19070]: 111020 20:12:59 [Note] /usr/sbin/mysqld: Shutdown complete
Oct 20 20:12:59 zulu1151 mysqld_safe[19070]: 
Oct 20 20:13:05 zulu1151 mysqld_safe[19101]: 111020 20:13:05 [Note] Plugin 'FEDERATED' is disabled.
Oct 20 20:13:05 zulu1151 mysqld_safe[19101]: 111020 20:13:05  InnoDB: Started; log sequence number 0 44233
Oct 20 20:13:05 zulu1151 mysqld_safe[19101]: ERROR: 1064  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 'ALTER TABLE user ADD column Show_view_priv enum('N','Y') CHARACTER SET utf8 NOT ' at line 1
Oct 20 20:13:05 zulu1151 mysqld_safe[19101]: 111020 20:13:05 [ERROR] Aborting
Oct 20 20:13:05 zulu1151 mysqld_safe[19101]: 
Oct 20 20:13:05 zulu1151 mysqld_safe[19101]: 111020 20:13:05  InnoDB: Starting shutdown...
Oct 20 20:13:10 zulu1151 mysqld_safe[19101]: 111020 20:13:10  InnoDB: Shutdown completed; log sequence number 0 44233
Oct 20 20:13:10 zulu1151 mysqld_safe[19101]: 111020 20:13:10 [Note] /usr/sbin/mysqld: Shutdown complete

Code: Alles auswählen

Oct 21 09:52:51 zulu1151 mysqld: 111021  9:52:51 [ERROR] Cannot find or open table world_new/warden_data_result from
Oct 21 09:52:51 zulu1151 mysqld: the internal data dictionary of InnoDB though the .frm file for the
Oct 21 09:52:51 zulu1151 mysqld: table exists. Maybe you have deleted and recreated InnoDB data
Oct 21 09:52:51 zulu1151 mysqld: files but have forgotten to delete the corresponding .frm files
Oct 21 09:52:51 zulu1151 mysqld: of InnoDB tables, or you have moved .frm files to another database?
Oct 21 09:52:51 zulu1151 mysqld: or, the table contains indexes that this version of the engine
Oct 21 09:52:51 zulu1151 mysqld: doesn't support.
Oct 21 09:52:51 zulu1151 mysqld: See http://dev.mysql.com/doc/refman/5.1/en/innodb-troubleshooting.html
Oct 21 09:52:51 zulu1151 mysqld: how you can resolve the problem.

Aus http://dev.mysql.com/doc/refman/5.1/en/ ... oting.html werde ich auch nicht schlau.

Kann wer helfen ?

lg