![]() |
![]() |
|
|
|||||||
| Linux, UNIX, Open Source Rat & Tat bei Problemen und Fragen rund um GNU/Linux, BSD und sonstige UNIXe |
![]() |
|
|
Themen-Optionen | Ansicht |
|
|
|
|
#1 |
|
Senior Member
![]() Registriert seit: 08.11.2000
Beiträge: 108
|
Hoffe, dass mir jemand weiterhelfen kann.
Ich habe auf einem W2K-Server MySQL installiert. Soweit lief auch alles gut, bis ich den Server neu starten musste. Nun lässt sich MySQL weder als Dienst noch als Standalone starten. Die Error-Datei gibt folgende Fehler aus: InnoDB: The first specified data file .\ibdata1 did not exist: InnoDB: a new database to be created! 030606 8:04:35 InnoDB: Setting file .\ibdata1 size to 10 MB InnoDB: Database physically writes the file full: wait... 030606 8:04:35 InnoDB: Log file .\ib_logfile0 did not exist: new to be created InnoDB: Setting log file .\ib_logfile0 size to 5 MB InnoDB: Database physically writes the file full: wait... 030606 8:04:36 InnoDB: Log file .\ib_logfile1 did not exist: new to be created InnoDB: Setting log file .\ib_logfile1 size to 5 MB InnoDB: Database physically writes the file full: wait... InnoDB: Doublewrite buffer not found: creating new InnoDB: Doublewrite buffer created InnoDB: Creating foreign key constraint system tables InnoDB: Foreign key constraint system tables created 030606 8:04:40 InnoDB: Started mysqld-nt: ready for connections. Version: '4.0.13-nt-log' socket: '' port: 3306 030606 8:07:16 mysqld-nt: Normal shutdown 030606 8:07:16 InnoDB: Starting shutdown... 030606 8:07:17 InnoDB: Shutdown completed 030606 8:07:17 mysqld-nt: Shutdown Complete 030606 8:19:06 InnoDB: Started MySql: ready for connections. Version: '4.0.13-nt-log' socket: '' port: 3306 030607 22:25:50 MySql: Normal shutdown 030607 22:25:51 InnoDB: Starting shutdown... 030607 22:25:54 InnoDB: Shutdown completed 030607 22:25:54 MySql: Shutdown Complete 030607 22:29:20 InnoDB: Started MySql: ready for connections. Version: '4.0.13-nt-log' socket: '' port: 3306 030723 17:22:13 MySql: Normal shutdown 030723 17:22:15 InnoDB: Starting shutdown... 030723 17:22:25 InnoDB: Shutdown completed 030723 17:22:25 MySql: Shutdown Complete 030723 17:25:59 InnoDB: Started 030723 17:25:59 Fatal error: Can't open privilege tables: Table 'mysql.host' doesn't exist 030723 17:25:59 Aborting 030723 17:25:59 InnoDB: Starting shutdown... 030723 17:26:01 InnoDB: Shutdown completed 030723 17:26:01 MySql: Shutdown Complete 030724 8:33:06 InnoDB: Started 030724 8:33:06 Fatal error: Can't open privilege tables: Table 'mysql.host' doesn't exist 030724 8:33:06 Aborting 030724 8:33:06 InnoDB: Starting shutdown... 030724 8:33:08 InnoDB: Shutdown completed 030724 8:33:08 MySql: Shutdown Complete 030724 8:33:18 InnoDB: Started 030724 8:33:18 Fatal error: Can't open privilege tables: Table 'mysql.host' doesn't exist 030724 8:33:18 Aborting 030724 8:33:18 InnoDB: Starting shutdown... 030724 8:33:20 InnoDB: Shutdown completed 030724 8:33:20 MySql: Shutdown Complete 030724 8:33:52 InnoDB: Started 030724 8:33:52 Fatal error: Can't open privilege tables: Table 'mysql.host' doesn't exist 030724 8:33:52 Aborting 030724 8:33:52 InnoDB: Starting shutdown... 030724 8:33:54 InnoDB: Shutdown completed 030724 8:33:54 MySql: Shutdown Complete 030724 9:02:19 InnoDB: Started 030724 9:02:19 Fatal error: Can't open privilege tables: Table 'mysql.host' doesn't exist 030724 9:02:19 Aborting 030724 9:02:19 InnoDB: Starting shutdown... 030724 9:02:21 InnoDB: Shutdown completed 030724 9:02:21 MySql: Shutdown Complete 030724 9:03:07 InnoDB: Started 030724 9:03:07 Fatal error: Can't open privilege tables: Table 'mysql.host' doesn't exist 030724 9:03:07 Aborting 030724 9:03:07 InnoDB: Starting shutdown... 030724 9:03:09 InnoDB: Shutdown completed 030724 9:03:09 MySql: Shutdown Complete 030724 9:20:16 InnoDB: Started 030724 9:20:16 Fatal error: Can't open privilege tables: Table 'mysql.host' doesn't exist 030724 9:20:16 Aborting 030724 9:20:16 InnoDB: Starting shutdown... 030724 9:20:18 InnoDB: Shutdown completed 030724 9:20:18 mysqld-nt: Shutdown Complete 030724 10:29:12 InnoDB: Started 030724 10:29:16 Fatal error: Can't open privilege tables: Table 'mysql.host' doesn't exist 030724 10:29:16 Aborting 030724 10:29:16 InnoDB: Starting shutdown... 030724 10:29:18 InnoDB: Shutdown completed 030724 10:29:19 mysqld: Shutdown Complete 030724 10:30:10 InnoDB: Started 030724 10:30:10 Fatal error: Can't open privilege tables: Table 'mysql.host' doesn't exist 030724 10:30:10 Aborting 030724 10:30:10 InnoDB: Starting shutdown... 030724 10:30:12 InnoDB: Shutdown completed 030724 10:30:12 MySql: Shutdown Complete 030724 10:42:43 InnoDB: Started 030724 10:42:43 Fatal error: Can't open privilege tables: Table 'mysql.host' doesn't exist 030724 10:42:43 Aborting 030724 10:42:43 InnoDB: Starting shutdown... 030724 10:42:45 InnoDB: Shutdown completed 030724 10:42:45 MySql: Shutdown Complete Wie ersichtlich kann MySQL anscheinend nicht starten, da die InnoDB einen Fehler verursacht (Fatal error: Can't open privilege tables: Table 'mysql.host' doesn't exist) Da ich in MySQL nicht so bewandert bin (blutiger newbie) sagt mir die Fehlermeldung nichts. Ich wüsste auch nicht, dass ich die InnoDB verwende. Auf dem Server sehe ich auch keine InnoDB Dateien oder Verzeichnisse. Falls notwendig, kann ich auch die my.cfg posten. Wäre für eine rasche Hilfe sehr dankbar! |
|
|
|
![]() |
| Aktive Benutzer in diesem Thema: 1 (Registrierte Benutzer: 0, Gäste: 1) | |
|
|