After a power outage, I can not start the MySQL. here is the error message and error log:
Error: MySQL shutdown unexpectedly.
13:16:14 [mysql] This may be due to a blocked port, missing dependencies,
13:16:14 [mysql] improper privileges, a crash, or a shutdown by another method.
13:16:14 [mysql] Press the Logs button to view error logs and check2025-01-22 16:15:21 0 [Note] InnoDB: Waiting for purge to start
2025-01-22 16:15:21 0 [Note] InnoDB: 10.4.32 started; log sequence number 16560891; transaction id 10071
2025-01-22 16:15:21 0 [Note] InnoDB: Loading buffer pool(s) from C:\xampp\mysql\data\ib_buffer_pool
2025-01-22 16:15:21 0 [Note] Plugin 'FEEDBACK' is disabled.
2025-01-22 16:15:21 0 [Note] Server socket created on IP: '::'.
2025-01-22 16:19:20 0 [Note] Starting MariaDB 10.4.32-MariaDB source revision c4143f909528e3fab0677a28631d10389354c491 as process 2784
2025-01-22 16:19:20 0 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2025-01-22 16:19:20 0 [Note] InnoDB: Uses event mutexes
2025-01-22 16:19:20 0 [Note] InnoDB: Compressed tables use zlib 1.3
2025-01-22 16:19:20 0 [Note] InnoDB: Number of pools: 1
2025-01-22 16:19:20 0 [Note] InnoDB: Using SSE2 crc32 instructions
2025-01-22 16:19:20 0 [Note] InnoDB: Initializing buffer pool, total size = 16M, instances = 1, chunk size = 16M
2025-01-22 16:19:20 0 [Note] InnoDB: Completed initialization of buffer pool
2025-01-22 16:19:20 0 [Note] InnoDB: 128 out of 128 rollback segments are active.
2025-01-22 16:19:20 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2025-01-22 16:19:20 0 [Note] InnoDB: Setting file 'C:\xampp\mysql\data\ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2025-01-22 16:19:20 0 [Note] InnoDB: File 'C:\xampp\mysql\data\ibtmp1' size is now 12 MB.
2025-01-22 16:19:20 0 [Note] InnoDB: Waiting for purge to start
2025-01-22 16:19:20 0 [Note] InnoDB: 10.4.32 started; log sequence number 16560900; transaction id 10071
2025-01-22 16:19:20 0 [Note] InnoDB: Loading buffer pool(s) from C:\xampp\mysql\data\ib_buffer_pool
2025-01-22 16:19:20 0 [Note] Plugin 'FEEDBACK' is disabled.
2025-01-22 16:19:20 0 [Note] Server socket created on IP: '::'.don’t not worry about the line “Physically writing the file full”. It’s not the main problem of the issue.
The solution is sample. You do not need reinstall XAMPP!!!
1. Rename the folder mysql/data to mysql/data_old (you can use any name)
2. Create a new folder mysql/data
3. Copy the content that resides in mysql/backup to the new mysql/data folder
4. Copy all your database folders that are in mysql/data_old to mysql/data (skipping the mysql, performance_schema, and phpmyadmin folders from data_old)
Finally copy the ibdata1 file from mysql/data_old and replace it inside mysql/data folder
5. Start MySQL from XAMPP control panel.