2023-12-21 22:39:15 0 [Note] InnoDB: Uses event mutexes
2023-12-21 22:39:15 0 [Note] InnoDB: Compressed tables use zlib 1.2.12
2023-12-21 22:39:15 0 [Note] InnoDB: Number of pools: 1
2023-12-21 22:39:15 0 [Note] InnoDB: Using SSE2 crc32 instructions
2023-12-21 22:39:15 0 [Note] InnoDB: Initializing buffer pool, total size = 16M, instances = 1, chunk size = 16M
2023-12-21 22:39:15 0 [Note] InnoDB: Completed initialization of buffer pool
2023-12-21 22:39:15 0 [Note] InnoDB: 128 out of 128 rollback segments are active.
2023-12-21 22:39:15 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2023-12-21 22:39:15 0 [Note] InnoDB: Setting file ‘C:\xampp\mysql\data\ibtmp1’ size to 12 MB. Physically writing the file full; Please wait …
2023-12-21 22:39:15 0 [Note] InnoDB: File ‘C:\xampp\mysql\data\ibtmp1’ size is now 12 MB.
2023-12-21 22:39:15 0 [Note] InnoDB: Waiting for purge to start
2023-12-21 22:39:15 0 [Note] InnoDB: 10.4.27 started; log sequence number 3145652; transaction id 9606
2023-12-21 22:39:15 0 [Note] InnoDB: Loading buffer pool(s) from C:\xampp\mysql\data\ib_buffer_pool
2023-12-21 22:39:15 0 [Note] Plugin ‘FEEDBACK’ is disabled.
2023-12-21 22:39:15 0 [Note] Server socket created on IP: ‘::’
Step -by step approach
- Go to the MySQL Data Directory and delete the following files except for the ibdata1. Look at the (production MySQL data below)
- Go the the backup folder of MySQL and copy everything except for the 1bdata1 into the main Data folder. Look at the (Backup MySql data below)
- Restart your XAMPP for both Apache server and the MySQL

Data Folder will be xampp/mysql/data <– Production Mysql data

Data Folder will be xampp/mysql/backup <— Backup MySql data
