Movatterモバイル変換


[0]ホーム

URL:


Skip to content
DEV Community
Log in Create account

DEV Community

Pradeep Kumar
Pradeep Kumar

Posted on

     

How to FIX: Error: MySQL shutdown unexpectedly

Important: do not delete theibdata1 file. You could destroy all your databases.

Steps:

  1. Rename foldermysql/data ->mysql/data_old

  2. Make a copy ofmysql/backup folder and name it asmysql/data

  3. Copy all yourdatabase folders only frommysql/data_old intomysql/data (exceptmysql, performance_schema, and phpmyadmin folders)

  4. Copymysql/data_old/ibdata1 file intomysql/data folder

  5. Start MySQL from XAMPP control panel

It should resolve the issue.

Top comments(1)

Subscribe
pic
Create template

Templates let you quickly answer FAQs or store snippets for re-use.

Dismiss
CollapseExpand
 
manchumahara profile image
Sabuj Kundu
  • Joined

This is correct and safe solution.

Are you sure you want to hide this comment? It will become hidden in your post, but will still be visible via the comment'spermalink.

For further actions, you may consider blocking this person and/orreporting abuse

𝗧𝗲𝗰𝗵𝗶𝗲 + 𝗚𝗲𝗲𝗸 + 𝗘𝗻𝘁𝗿𝗲𝗽𝗿𝗲𝗻𝗲𝘂𝗿 | Your perception of life is your life | Dreams don't work unless you do | Don't freak out, figure out!
  • Location
    Delhi, India
  • Work
    CEO at WebReinvent
  • Joined

Trending onDEV CommunityHot

DEV Community

We're a place where coders share, stay up-to-date and grow their careers.

Log in Create account

[8]ページ先頭

©2009-2025 Movatter.jp