Update xampp from maria db 10.1 to 10.2
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 : 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
14 : Run xampp/mysql/bin/mysql_upgrade.exe.
15 : 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 please remove or commented this statement in my.ini file in this path xampp/mysql/bin/my.ini file.
Help from this link.
Upgrading MariaDB 10.1.32 version to 10.3.7
In general, for any upgrade for a critical production environment:
- The best approach is to use or create a test environment that is as close as possible to your production environment and test the upgrade there.
- Make backups and prepare a rollback so you are ready to undo your changes
For MariaDB specifically: to quote from other related questions on their support pages:
The main concern with skipping versions is that, while upgrading one major version is usually well-tested, skipping versions is not, so you
may bump into an incompatibility
Even if you find anecdotal indications that it worked for others, a database engine like MariaDB has possible complexities with different storage engines and the like that might make it more tricky in certain setups than in others.
How to stop XAMPP's MySQL Service after updating MariaDB
You can kill the process operating on port 3306.
Type in CMD (Command Prompt) if you have windows:
netstat -ano | findstr :<yourPortNumber>
put your port number in the diamond brackets.
then put the process ID in diamond brackets,
taskkill /PID <typeyourPIDhere> /F
Related Topics
Avoiding Recursion with Doctrine Entities and Jmsserializer
Aws Sdk for PHP: Error Retrieving Credentials from the Instance Profile Metadata Server
The Correct Way to Delete All Files Older Than 2 Days in PHP
Detect "Overall Average" Color of the Picture
Generating Ssh Keys for 'Apache' User
Using Regular Expressions to Extract the First Image Source from HTML Codes
Convert Epoch Time to Date PHP
How to Get PHPunit Mockobjects to Return Different Values Based on a Parameter
How to Display Woocommerce Category Image
What Do Two Colons Mean in PHP
PHP - Getsqlvaluestring Function
How to Add Additional PHP Versions to Mamp
How to Receive a File via Http Put with PHP
Read in Text File Line by Line PHP - Newline Not Being Detected
Why Are Certain Types of Prepared Queries Using Pdo in PHP with MySQL Slow