将Xampp从Maria DB 10.1更新到10.2 [英] Update xampp from maria db 10.1 to 10.2

问题描述

我正在寻找有关如何在窗口系统上的xampp 32 bit上更新mariadb的解决方案，但未找到任何相关的文章.我只是找到了此

I am looking for solution on how to update mariadb on xampp 32 bit on window system but not found any article on that.I just found this link. Please help me how to update. I want JSON support that's why I am looking for update from V10.1 to V10.2. Or if there is any other way to do this please let me know

当前版本为10.1.19-MariaDB

推荐答案

1:从Xampp控制面板关闭或退出XAMPP服务器.
2:下载 MariaDB
的 ZIP版本 3:将xampp/mysql文件夹重命名为mysql_old.
4:解压缩或提取 MariaDB ZIP文件的内容到您的XAMPP中 文件夹.
5:将MariaDB文件夹重命名为mariadb-5.5.37-win32 mysql.
6:将xampp/mysql/data重命名为data_old.
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.找到跳过联合，并在其前面(左侧)添加#，以注释掉该行(如果存在).保存并退出编辑器.
13:启动XAMPP.
注意:如果无法从Xampp控制面板启动mysql. 在xampp/mysql/bin/my.ini中的任何位置添加此"skip-grant-tables"语句 文件
14:运行xampp/mysql/bin/mysql_upgrade.exe.
15:关闭并重新启动MariaDB(MySQL).
如果仍未启动 mysql，请遵循以下注意步骤(！重要)

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)

注意: mysql错误日志文件: c:\ xampp \ mysql \ bin \ mysqld.exe:未知变量'innodb_additional_mem_pool_size = 2M'，请删除或对此进行评论 xampp/mysql/bin/my.ini文件中的my.ini文件中的语句.

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.

此 查看全文