2

I tried to update MySQL from 5.0.12 to 5.7.18 but unable to start MySQL after upgrade. I performed following steps.

  • I downloaded Zip Archive file from MySQL Community Server.
  • I extracted the archive file in Temp Folder.
  • I renamed the mysql folder to mysql_backup
  • I created a new mysql folder and pasted all the newly extracted files in that folder
  • I copied data folder from old mysql_backup folder to newly created mysql folder.
  • I copied my.ini from old mysql_backup folder to new mysql folder's bin directory.
  • I tried to start mysql service but it gives error.

enter image description here

  • I removed following line as per this suggestion but still same error. innodb_additional_mem_pool_size = 2M

There is nothing in error log of mysql. It seems to be my.ini issue. Please help me out.

Community
  • 1
  • 1
Umair Malhi
  • 565
  • 1
  • 5
  • 16

2 Answers2

2

At last I have found the answer using Windows Event Viewer. The issue was with the below line in [mysqld] section which I have commented-out/removed from my.ini file and now MySQL have started:

key_buffer = 16M

After commenting this out this line will be:

#key_buffer = 16M

Please do check your Windows Event Viewer for more clues to the errors in XAMPP Control Panel.

Umair Malhi
  • 565
  • 1
  • 5
  • 16
0

In my case, I had to move the my.ini file from /data folder to /bin folder

Azmeer
  • 734
  • 6
  • 15