4 Haziran 2009 Perşembe

mysql restart ettiginizde calismiyor veya InnoDB: default storage engine is not available hatalar veriyorsa

Mysql ,

bazen bilinmeyen bir sebeple calismaya bilir hata mesajlari asagidaki gibidir;

Cozumu ise oldukca basit ;

[mysqld]
tmpdir=C:/temp

Kaynak: http://dev.mysql.com/doc/refman/5.0/en/cannot-create.html

default storage engine is not available

InnoDB: The log sequence number in ibdata files does not match
InnoDB: the log sequence number in the ib_logfiles!
090603 13:27:55 InnoDB: Database was not shut down normally!
InnoDB: Starting crash recovery.

InnoDB: The first specified data file .\ibdata1 did not exist:
InnoDB: a new database to be created!
080916 4:10:41 InnoDB: Setting file .\ibdata1 size to 10 MB
InnoDB: Database physically writes the file full: wait...
080916 4:10:41 InnoDB: Log file .\ib_logfile0 did not exist: new to be created
InnoDB: Setting log file .\ib_logfile0 size to 50 MB
InnoDB: Database physically writes the file full: wait...
080916 4:10:42 InnoDB: Log file .\ib_logfile1 did not exist: new to be created
InnoDB: Setting log file .\ib_logfile1 size to 50 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
080916 4:10:44 InnoDB: Started; log sequence number 0 0
080916 4:10:44 [Note] C:\MySQL5\bin\mysqld-nt: ready for connections.
Version: '5.0.67-community-nt' socket: '' port: 3306 MySQL Community Edition (GPL)
080918 3:01:30 [Note] C:\MySQL5\bin\mysqld-nt: Normal shutdown

Hiç yorum yok: