Troubleshooting the MySQL Server 5.1 service on Windows Vista

Although some users have reported success, most installations I've tried of MySQL 5.1 on Vista have failed, even on fresh Vista installs. The first problem appears at the end of the service instance configuration. All appears to be well, however the server refuses to start with Could not start MySQL service or Could not start the service MySQL. Error: 0.

The trick is to start MySQL from the console so that you are able to see the error message (you can access the command console by typing cmd into the Run dialog):

cd "C:\Program Files\MySQL\MySQL Server 5.1\bin"
mysqld -nt --defaults-file="C:\Program Files\MySQL\MySQL Server 5.1\my.ini" --standalone --console

In my case, MySQL always returned the same error message:

Plugin 'InnoDB' init function returned error.
Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
Unknown/unsupported table type: INNODB
Aborting
Forcing shutdown of 1 plugins

This message is a symptom of the log file size problem (just google InnoDB: Error: log file .\ib_logfile0 is of different size for more information). All you need to do is to clear the following files from the folder C:\ProgramData\MySQL\MySQL Server 5.1\data:

ib_logfile0
ib_logfile1
ibdata1
$YOUR_HOSTNAME$.err

Restart the MySQL server and all should be well. Note that the C:\ProgramData\ folder is hidden, so unless you have enabled hidden folders from the Folder Options dialog, you will need to copy/paste that folder path directly into the address bar in order to access the folder.

Rating: 

Comments

Thank you so much for this detailed and clear solution which solved my issue after lots of time roaming on the net !

Man, I was going crazy with that. Mainly considering the incredible number of post regarding such kind of error, but that it.
You suggestion worked perfectly.

Thanks a lot.

In my case it is Windows Server 2003. The folder path is C:\Documents and Settings\All Users\Application Data\MySQL\MySQL Server 5.1\data

waaaaa....thanks

This solved my issues with installing MySQL on Vista. Thank you very much for posting this!

D:\>cd D:\ANDROID SW\mysql-5.6.14-win32\mysql-5.6.14-win32\bin

D:\ANDROID SW\mysql-5.6.14-win32\mysql-5.6.14-win32\bin>mysqld --console
2016-04-27 20:30:08 0 [Warning] TIMESTAMP with implicit DEFAULT value is
ted. Please use --explicit_defaults_for_timestamp server option (see docu
on for more details).
2016-04-27 20:30:08 3644 [Note] Plugin 'FEDERATED' is disabled.
2016-04-27 20:30:08 3644 [Note] InnoDB: The InnoDB memory heap is disable
2016-04-27 20:30:08 3644 [Note] InnoDB: Mutexes and rw_locks use Windows
cked functions
2016-04-27 20:30:08 3644 [Note] InnoDB: Compressed tables use zlib 1.2.3
2016-04-27 20:30:08 3644 [Note] InnoDB: Not using CPU crc32 instructions
2016-04-27 20:30:08 13c4 InnoDB: Error: unable to create temporary file;
2
2016-04-27 20:30:08 3644 [ERROR] Plugin 'InnoDB' init function returned e
2016-04-27 20:30:08 3644 [ERROR] Plugin 'InnoDB' registration as a STORAG
E failed.
2016-04-27 20:30:08 3644 [ERROR] Unknown/unsupported storage engine: Inno
2016-04-27 20:30:08 3644 [ERROR] Aborting

2016-04-27 20:30:08 3644 [Note] Binlog end
2016-04-27 20:30:08 3644 [Note] Shutting down plugin 'partition'
2016-04-27 20:30:08 3644 [Note] Shutting down plugin 'PERFORMANCE_SCHEMA'
2016-04-27 20:30:08 3644 [Note] Shutting down plugin 'INNODB_SYS_DATAFILE
2016-04-27 20:30:08 3644 [Note] Shutting down plugin 'INNODB_SYS_TABLESPA
2016-04-27 20:30:08 3644 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN_
2016-04-27 20:30:08 3644 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN'
2016-04-27 20:30:08 3644 [Note] Shutting down plugin 'INNODB_SYS_FIELDS'
2016-04-27 20:30:08 3644 [Note] Shutting down plugin 'INNODB_SYS_COLUMNS'
2016-04-27 20:30:08 3644 [Note] Shutting down plugin 'INNODB_SYS_INDEXES'
2016-04-27 20:30:08 3644 [Note] Shutting down plugin 'INNODB_SYS_TABLESTA
2016-04-27 20:30:08 3644 [Note] Shutting down plugin 'INNODB_SYS_TABLES'
2016-04-27 20:30:08 3644 [Note] Shutting down plugin 'INNODB_FT_INDEX_TAB
2016-04-27 20:30:08 3644 [Note] Shutting down plugin 'INNODB_FT_INDEX_CAC
2016-04-27 20:30:08 3644 [Note] Shutting down plugin 'INNODB_FT_CONFIG'
2016-04-27 20:30:08 3644 [Note] Shutting down plugin 'INNODB_FT_BEING_DEL
2016-04-27 20:30:08 3644 [Note] Shutting down plugin 'INNODB_FT_DELETED'
2016-04-27 20:30:08 3644 [Note] Shutting down plugin 'INNODB_FT_DEFAULT_S
'
2016-04-27 20:30:08 3644 [Note] Shutting down plugin 'INNODB_METRICS'
2016-04-27 20:30:08 3644 [Note] Shutting down plugin 'INNODB_BUFFER_POOL_
2016-04-27 20:30:08 3644 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE_
2016-04-27 20:30:08 3644 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE'
2016-04-27 20:30:08 3644 [Note] Shutting down plugin 'INNODB_CMP_PER_INDE
'
2016-04-27 20:30:08 3644 [Note] Shutting down plugin 'INNODB_CMP_PER_INDE
2016-04-27 20:30:08 3644 [Note] Shutting down plugin 'INNODB_CMPMEM_RESET
2016-04-27 20:30:08 3644 [Note] Shutting down plugin 'INNODB_CMPMEM'
2016-04-27 20:30:08 3644 [Note] Shutting down plugin 'INNODB_CMP_RESET'
2016-04-27 20:30:08 3644 [Note] Shutting down plugin 'INNODB_CMP'
2016-04-27 20:30:08 3644 [Note] Shutting down plugin 'INNODB_LOCK_WAITS'
2016-04-27 20:30:08 3644 [Note] Shutting down plugin 'INNODB_LOCKS'
2016-04-27 20:30:08 3644 [Note] Shutting down plugin 'INNODB_TRX'
2016-04-27 20:30:08 3644 [Note] Shutting down plugin 'BLACKHOLE'
2016-04-27 20:30:08 3644 [Note] Shutting down plugin 'ARCHIVE'
2016-04-27 20:30:08 3644 [Note] Shutting down plugin 'MRG_MYISAM'
2016-04-27 20:30:08 3644 [Note] Shutting down plugin 'MyISAM'
2016-04-27 20:30:08 3644 [Note] Shutting down plugin 'MEMORY'
2016-04-27 20:30:08 3644 [Note] Shutting down plugin 'CSV'
2016-04-27 20:30:08 3644 [Note] Shutting down plugin 'sha256_password'
2016-04-27 20:30:08 3644 [Note] Shutting down plugin 'mysql_old_password'
2016-04-27 20:30:08 3644 [Note] Shutting down plugin 'mysql_native_passwo
2016-04-27 20:30:08 3644 [Note] Shutting down plugin 'binlog'
2016-04-27 20:30:08 3644 [Note] mysqld: Shutdown complete

D:\ANDROID SW\mysql-5.6.14-win32\mysql-5.6.14-win32\bin>

I am having this issue. I am creating a database for my android application. but thus errors :(

I have never liked windows vista and it always cused me trouble on my system operations. I was always late on my assignments because the windows decided to go crasy whenever I needed to use my system. I am so thankful to you for prividing with these measures as only because of this was I able to fix the problem and now, its all good!

You can only get the clash royale cheats for the gems and gold online.
clash royale free gems
clash royale gems cheat
clash royale gems hack

National brand mulberry replica recently experienced a painful transition, the new British designer Jonathan Anderson on the Spanish royal Queen veteran has carried out radical reforms. Although the new Logo roughly respected in 1970 by the Spanish painter Vicente Vela created by the four capitals of the flower L logo, but regardless of advertising or product style have been up to 90% of the subversion, and even the previous classic calm camel packaging also has a capable The new image of the former. But we believe that replica handbags will be another LOEWE spring. Spring and summer of 2014 series of handbags from the Japanese origami inspired by the bag can be folded into a cardboard general plane, but also turned signal flags, ice bucket or pillow; small leather theme is "cheerful zoo", regardless of the Supermarket shopping or lunch break out foraging, nothing more than holding a panda out of Hermes Replica Handbags the belly from the elephant to take a more lovely thing, the cortex of the flexibility and sculpture are also played to the extreme.