Update xampp from maria db 10.1 to 10.2

Question

I am looking for a solution on how to update mariadbon xampp 32 bitin the window system, but did not find a single article on this; I mariadb xampp 32 bitjust found this link . Please help me how to update. I want JSONsupport, so I'm looking for an update from V10.1to V10.2. Or, if there is another way to do this, please let me know.

Current version 10.1.19-MariaDB

Answer 1

1: Shut down or exit the XAMPP server from the 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 to your XAMPP folder.
5: Rename the MariaDB folder, naming 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 / to xampp / mysql /.
11: Copy xampp / mysql_old / bin / my.ini to xampp / mysql / bin.
12: Edit xampp / mysql / bin / my.ini with a text editor such as Notepad. Find skip-federated and add in front of it (on the left) to comment on the line if it exists. Save and exit the editor.
13: Starting XAMPP.
 Note If you cannot force mysql to start from the Xampp control panel. Add this skip-grant-tables statement anywhere in the xampp / mysql / bin / my.ini file
14: Run xampp / mysql / bin / mysql_upgrade.exe.
15: Shutting down and restarting MariaDB (MySQL).
         If mysql is still not running, follow these steps Note (! Important)

Note : mysql error log file: c: \ xampp \ mysql \ bin \ mysqld.exe: unknown variable 'innodb_additional_mem_pool_size = 2M', for example, delete or comment on this in the my.ini file in this xampp / mysql / bin / my path . ini .

Help on this link.

Answer 2

I tried the same solution, which did not help me check the error log, and based on this I commented on this parameter because it is out of date.

Line number 145 in my.ini file
#innodb_additional_mem_pool_size = 2M

2018-02-17 23:08:47 bf0 InnoDB: Warning: Using innodb_additional_mem_pool_size is DEPRECATED. This option may be removed in future releases, together with the option innodb_use_sys_malloc and with the InnoDB internal memory allocator.

It worked for me.

Answer 3

:

: mysql: c:\xampp\mysql\bin\mysqld.exe: 'innodb_additional_mem_pool_size = 2M', , my.ini xampp/mysql/bin/my.ini.

, , ERROR:

2018-03-09 12:14:56 4116 [ERROR] mysqld.exe: '.\mysql\user' is 2018-03-09 12:14:56 4116 [Warning] :.\Mysql\user '2018-03-09 12:14:56 4116 [ERROR] mysql.user: 1

.

Answer 4

mysql_upgrade

mysqlcheck --repair --all-databases

Answer 5

1. MySQL XAMPP Xampp mysql "", .
2. ZIP- MariaDB (https://downloads.mariadb.org/) - winx64.zip, x64- mariadb
3. xampp/mysql mysql_old
4. ZIP MariaDB XAMPP
5. MariaDB, - mariadb-10.3.14-winx64, mysql
6. xampp/mysql/data data_temp
7. xampp/mysql_old/data xampp/mysql/
8. xampp/mysql_old/backup xampp/mysql/
9. xampp/mysql_old/scripts xampp/mysql/
10. mysql_uninstallservice.bat mysql_installservice.bat xampp/mysql_old/ xampp/mysql/
11. xampp/mysql_old/bin/my.ini xampp/mysql/bin
12. xampp/mysql/bin/my.ini ,

skip-federated # () , ,

innodb_additional_mem_pool_size = 2 # () , ,

skip-grant-tables xampp/mysql/bin/my.ini. .

13. XAMPP
14. xampp/mysql/bin/mysqlcheck --repair --all-database
15. xampp/mysql/bin/mysql_upgrade.exe
16. MySQL (MariaDB)

Answer 6

I followed the guide, but could not stop xampp after running mysql_upgrade, then noticed that I downloaded the x64 mariaDB zip folder ... I downloaded the x32 version and copied all the .ini files to xampp / mysql_old (my-huge. Ini, my- small.ini) and it worked like a charm.