Last active
October 17, 2024 11:29
-
-
Save fsuuaas/7639e580cb952817c65d3ae2db3d7e4f to your computer and use it in GitHub Desktop.
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
1 : Shutdown or Quit your XAMPP server from Xampp control panel. | |
2 : Download the ZIP version of MariaDB | |
3 : Rename the xampp/mysql folder to mysql_old. | |
4 : Unzip or Extract the contents of the MariaDB ZIP file into your XAMPP folder. | |
5 : Rename the MariaDB folder, called something like mariadb-5.5.37-win32, to mysql. | |
6 : Rename xampp/mysql/data to data_old. | |
7 : Copy the xampp/mysql_old/data folder to xampp/mysql/. | |
8 : Copy the xampp/mysql_old/backup folder to xampp/mysql/. | |
9 : Copy the xampp/mysql_old/scripts folder to xampp/mysql/. | |
10: Copy mysql_uninstallservice.bat and mysql_installservice.bat from xampp/mysql_old/ into xampp/mysql/. | |
11 : Copy xampp/mysql_old/bin/my.ini into xampp/mysql/bin. | |
12 : Edit xampp/mysql/bin/my.ini using a text editor like Notepad. Find skip-federated and add a # in front (to the left) of it to comment out the line if it exists. Save and exit the editor. | |
13: comment innodb_additional_mem_pool_size = 2M on my.ini | |
14 : Start-up XAMPP. | |
Note If you can't get mysql to start from Xampp control panel. Add this 'skip-grant-tables' statement anywhere in xampp/mysql/bin/my.ini file | |
15 : Run xampp/mysql/bin/mysql_upgrade.exe. | |
16 : Shutdown and restart MariaDB (MySQL). | |
If still mysql is not started then follow below Note steps(!Important) | |
Note :mysql error log file: c:\xampp\mysql\bin\mysqld.exe: unknown variable 'innodb_additional_mem_pool_size=2M' like |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment