Xampp Mysql Error

Xampp Mysql Error

If you are running Xampp and found that you experience MySQL Error with the following error message: (as describe below), you can solve the MySQL issues using the backup folder. Let me show you step by step how to resolve this and i am very sure you will save a lot of time rather debugging it. 2023-12-21 22:39:15 0 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
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

  1. Go to the MySQL Data Directory and delete the following files except for the ibdata1. Look at the (production MySQL data below)
  2. 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)
  3. 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

Related Posts
Leave a Reply

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