MySQL did not run in XAMP Control

Service related problem are often seen while working with applications. Today i could not start MYSQL service in xampp. it happened in Xampp-control. Well, I found this issue on windows 10 XAMP Control Panel (v3.2.4) today  when i have gone through logs.

Got the following error-

2019-08-08 14:50:31 0 [Note] InnoDB: Removed temporary tablespace data file: “ibtmp1”
2019-08-08 14:50:31 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2019-08-08 14:50:31 0 [Note] InnoDB: Setting file ‘C:\xampp\mysql\data\ibtmp1’ size to 12 MB. Physically writing the file full; Please wait…
2019-08-08 14:50:31 0 [Note] InnoDB: File ‘C:\xampp\mysql\data\ibtmp1’ size is now 12 MB.
2019-08-08 14:50:31 0 [Note] InnoDB: Waiting for purge to start
2019-08-08 14:50:31 0 [Note] InnoDB: 10.3.16 started; log sequence number 1890485; transaction id 245
2019-08-08 14:50:31 0 [Note] InnoDB: Loading buffer pool(s) from C:\xampp\mysql\data\ib_buffer_pool
2019-08-08 14:50:31 0 [Note] Plugin ‘FEEDBACK’ is disabled.
2019-08-08 14:50:31 0 [Note] Server socket created on IP: ‘::’.

Moreover, I tried  to fix this  using various sources i.e. community sites, blogs, FAQ.

Besides, could not get any proper solutions on time.

finally, i got the solution which worked for me.

Solution

From xampp/mysql/backup/ folder i copied all files and paste into xampp/mysql/data/ directory
and successfully run the MySQL service .

Leave a Reply

Your email address will not be published. Required fields are marked *

error: Content is protected !!