The resolution database could not be started

Get up this morning , Suddenly I found my database collapsed , see errorr journal , See because ibtmp1 A file that stores information , The size exceeds the limit , But I tried to change mysql The port of , I also tried to change the file size limit , But it doesn't seem to work .

When I checked the data, I found ,xmapp Medium data Is the backup place of our database , Let me think , Since the database has a backup place , Can we back up the data , Then delete the software , Reinstall the software , Is it OK to replace the backup files later .

After trying, the result is OK

among test For my sql The main place of the document , But to be on the safe side , I put data The files are copied to the desktop , After that htdocs Save the file , Because this is us html,js,php Where your code is stored .

After saving it , We started reloading

  After reloading , I found that I just put my test Replace... In the file test, Can't access our database , So I put it back data Medium

This file replaces the corresponding location after we reinstall ibdata1, Because he keeps our database information , After the restart Xampp, We can call our previous database , By the way, don't forget to htdocs Replace the file, too , If you are unclear, you can leave a message to the author in the comment area