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.
From xampp/mysql/backup/ folder i copied all files and paste into xampp/mysql/data/ directory
and successfully run the MySQL service .
Shree is based in Butwal, Nepal. Shree holds a degree in M.Sc. (IT) and began working at New Horizons, Nepal Center in 2007-2012. After that Shree contributes to various reputed firms in Kathmandu with his years’ of experiences in Teaching, IT administration, Management and Consulting Services especially in Payment/Software industries (IT infrastructures and Security solution). Check about page for details!