MySQL Forums
Forum List  »  Quality Assurance

Help me! I can't start mysql services.
Posted by: eos li
Date: May 27, 2008 09:25PM

I created an database and I removed it yesterday afternoon.
And then I exited the mysql.
Then I changed the character set from gb2313 to utf8 and restart the services.
But I couldn't restart it.

The error information in *.err like that:
--------------------------------------------------------------------------------
080527 9:35:33 InnoDB: Started; log sequence number 0 43655
080527 9:35:33 [Note] C:\Program Files\MySQL\MySQL Server 5.0\bin\mysqld-nt: ready for connections.
Version: '5.0.18-nt' socket: '' port: 3306 MySQL Community Edition (GPL)
080527 16:38:56 [Note] C:\Program Files\MySQL\MySQL Server 5.0\bin\mysqld-nt: Normal shutdown

080527 16:38:58 [Warning] C:\Program Files\MySQL\MySQL Server 5.0\bin\mysqld-nt: Forcing close of thread 1 user: 'root'

080527 16:38:58 InnoDB: Starting shutdown...
080527 16:39:00 InnoDB: Shutdown completed; log sequence number 0 43665
080527 16:39:00 [Note] C:\Program Files\MySQL\MySQL Server 5.0\bin\mysqld-nt: Shutdown complete

InnoDB: The first specified data file .\ibdata1 did not exist:
InnoDB: a new database to be created!
080527 16:39:00 InnoDB: Setting file .\ibdata1 size to 10 MB
InnoDB: Database physically writes the file full: wait...
InnoDB: Error: all log files must be created at the same time.
InnoDB: All log files must be created also in database creation.
InnoDB: If you want bigger or smaller log files, shut down the
InnoDB: database and make sure there were no errors in shutdown.
InnoDB: Then delete the existing log files. Edit the .cnf file
InnoDB: and start the database again.
080527 16:39:01 [ERROR] Default storage engine (InnoDB) is not available
080527 16:39:01 [ERROR] Aborting
---------------------------------------------------------------------------------

Options: ReplyQuote


Subject
Views
Written By
Posted
Help me! I can't start mysql services.
4852
May 27, 2008 09:25PM
2365
May 27, 2008 09:31PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.