Take the 2-minute tour ×
Server Fault is a question and answer site for professional system and network administrators. It's 100% free, no registration required.

After uninstalling mysql 5.1 (64 bit version) I cannot install the win32 version! Apparently the devs felt it neccasery to leave helpful artifacts behind? I have rebooted my machine but no effect..

Running this:

C:\Users\User1>net start mysql
The MySQL service is starting.
The MySQL service could not be started.

A system error has occurred.

System error 1067 has occurred.

The process terminated unexpectedly.

And ran this:

C:\Program Files (x86)\MySQL\MySQL Server 5.1\bin>mysqld --console
100213 10:52:58 [Note] Plugin 'FEDERATED' is disabled.
InnoDB: Error: log file .\ib_logfile0 is of different size 0 10485760 bytes
InnoDB: than specified in the .cnf file 0 25165824 bytes!
100213 10:52:59 [ERROR] Plugin 'InnoDB' init function returned error.
100213 10:52:59 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.

100213 10:52:59 [ERROR] Unknown/unsupported table type: INNODB
100213 10:52:59 [ERROR] Aborting

100213 10:52:59 [Note] mysqld: Shutdown complete

Update: For some reason it looks like it is installing the 32bit DB into the old 64bit directoy.... will look into this... (the bin directory is going into the 32 bit program files directory).

share|improve this question
    
Please provide more context (such as error messages). This makes it a lot easier for us to answer your questions. –  Aron Rotteveel Feb 13 '10 at 15:50
    
Yah beat me to it brah. –  Zombies Feb 13 '10 at 15:54

2 Answers 2

up vote 0 down vote accepted

"log file .\ib_logfile0 is of different size" is a clue that your config file (my.cnf) and the contents of the data directory don't match anymore. I'd uninstall, look for whatever directory ib_logfile0 is in, move the contents of that directory somewhere else, and reinstall. On the other hand, if you want to keep the databases from the 64-bit instance, you might be able to just rename the InnoDB log files, and MySQL will recreate them when it starts.

The installer probably doesn't delete the data directory during an uninstall because someone might not expect their databases to get deleted.

share|improve this answer

I had the same problem. Unfortunately I tried so many things that I can't give you the exact "walk through". Anyway, try this:

  1. Uninstall MySQL from the Control Panel
  2. check in C:\Program Files\MySQL\MySQL Server 5.1\my.ini (or C:\Program Files (86)\MySQL\MySQL Server 5.1\my.ini) for the data files location. This is what i had:

    datadir="C:/ProgramData/MySQL/MySQL Server 5.1/Data/"
    
  3. delete the folder C:/ProgramData/MySQL/. Other option is C:\MySQL InnoDB Datafiles or something like that.

  4. Install MySQL but do not run the configuration. Stop after the software is installed

  5. Go to C:\Program Files\MySQL\MySQL Server 5.1\bin\ and rigth-click on MySQLInstanceConfig.exe. Select "Run as Administrator"

  6. Leave all the options as default, if the setup ask for the old password, it means it still finds the older datafiles somewhere. So start all over again and try to find where the old data files are.

Other course of action is, during the installation, when asked about wich database to install, select the last option (I dont remember the name) for MyISAM. This will install in C:\ProgramData.... After this, go back to the item 1 (uninistall, erase, etc)

Hope this helps. I used mysql-essential-5.1.46.-win32.msi package, but I'm pretty sure its the same for the 64bit.

Regards Alex

share|improve this answer
    
step 5 saved my day. Thanks! –  Yenchi Feb 8 '13 at 23:52

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.