php 将 xampp 从 maria db 10.1 更新到 10.2

Update xampp from maria db 10.1 to 10.2

提问by Kapil Sharma

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

我在寻找解决方案如何更新mariadb在xampp 32 bit视窗系统上，但没有发现任何that.I文章刚刚发现这个链接。请帮我如何更新。我需要JSON支持，这就是为什么我正在寻找从V10.1到 的更新V10.2。或者如果有任何其他方法可以做到这一点，请告诉我

Current version is 10.1.19-MariaDB

当前版本是 10.1.19-MariaDB

回答by Sumit

1 : Shutdown or Quit your XAMPP server from Xampp control panel.
2 : Download the ZIP versionof MariaDB
3 : Rename the xampp/mysql folder to mysql_old.
4 : Unzipor Extractthe 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-federatedand 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.
NoteIf 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)

1：从 Xampp 控制面板关闭或退出您的 XAMPP 服务器。
2：下载ZIP版的MariaDB的
3：重命名XAMPP / MySQL的文件夹mysql_old。
4 :将MariaDB ZIP 文件的内容解压缩或解压到您的 XAMPP 文件夹中。
5：将 MariaDB 文件夹重命名为 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。找到skip-federated并在它的前面（左侧）添加一个 # 以注释掉该行（如果它存在）。保存并退出编辑器。
13：启动XAMPP。
注意如果您无法从 Xampp 控制面板启动 mysql。在 xampp/mysql/bin/my.ini 文件中的任何位置添加此“skip-grant-tables”语句
14：运行 xampp/mysql/bin/mysql_upgrade.exe。
15 : 关闭并重新启动 MariaDB (MySQL)。
如果仍然没有启动 mysql 则按照以下注意步骤（！重要）

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.

注意：mysql 错误日志文件：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 文件。

Help from this link.

来自此链接的帮助。

回答by Rana Hussain

I tried the same solution did not work for me check the error log and based on this i commented out this option because it has been deprecated.

我尝试了相同的解决方案对我不起作用检查错误日志并基于此我注释掉了此选项，因为它已被弃用。

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's internal memory allocator.

It worked for me.

它对我有用。

回答by edmoncuaft

1. Shutdown MySQLin your XAMPP server from Xampp control panel or mysqlunder Services if it was added.
2. Download the ZIP version of MariaDB (https://downloads.mariadb.org/) - you may download the winx64.zipif you are also switching to x64 variant of mariadb
3. Rename the xampp/mysqlfolder 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-10.3.14-winx64, to mysql
6. Rename xampp/mysql/datato data_temp
7. Copy the xampp/mysql_old/datafolder to xampp/mysql/
8. Copy the xampp/mysql_old/backupfolder to xampp/mysql/
9. Copy the xampp/mysql_old/scriptsfolder to xampp/mysql/
10. Copy mysql_uninstallservice.batand mysql_installservice.batfrom xampp/mysql_old/into xampp/mysql/
11. Copy xampp/mysql_old/bin/my.iniinto xampp/mysql/bin
12. Edit xampp/mysql/bin/my.iniusing a text editor like Notepad

1. 如果已添加，请从 Xampp 控制面板或服务下的mysql关闭XAMPP 服务器中的MySQL。
2. 下载MariaDB的ZIP版本（https://downloads.mariadb.org/） -您可以下载winx64.zip如果你也切换到MariaDB的的64变种
3. 将xampp/mysql文件夹重命名为mysql_old
4. 将 MariaDB ZIP 文件的内容解压缩或解压到您的 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

Find skip-federatedand add a # in front (to the left) of it to comment out the line if it exists

找到skip-federated并在它的前面（左侧）添加一个 # 以注释掉该行（如果存在）

Find innodb_additional_mem_pool_size=2and add a # in front (to the left) of it to comment out the line if it exists

找到innodb_additional_mem_pool_size=2并在其前面（左侧）添加一个 # 以注释掉该行（如果存在）

Add this skip-grant-tablesstatement anywhere in xampp/mysql/bin/my.ini file Save and exit the editor

在 xampp/mysql/bin/my.ini 文件中的任意位置添加此skip-grant-tables语句 保存并退出编辑器

1. Start-up XAMPP
2. Run xampp/mysql/bin/mysqlcheck --repair --all-databases
3. Run xampp/mysql/bin/mysql_upgrade.exe
4. Shutdown and restart MySQL(MariaDB)

13. 启动 XAMPP
14. 运行xampp/mysql/bin/mysqlcheck --repair --all-databases
15. 运行xampp/mysql/bin/mysql_upgrade.exe
16. 关闭并重新启动MySQL(MariaDB)

回答by Vladan Ulardzic

This:

这个：

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.

注意：mysql错误日志文件：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 文件。

also helped me except that I had the following ERROR message:

也帮助了我，除了我收到以下错误消息：

2018-03-09 12:14:56 4116 [ERROR] mysqld.exe: Table '.\mysql\user' is marked as crashed and should be repaired 2018-03-09 12:14:56 4116 [Warning] Checking table: '.\mysql\user' 2018-03-09 12:14:56 4116 [ERROR] mysql.user: 1 client is using or hasn't closed the table properly

2018-03-09 12:14:56 4116 [ERROR] mysqld.exe: Table '.\mysql\user' 被标记为崩溃，应该修复 2018-03-09 12:14:56 4116 [Warning] 检查表: '.\mysql\user' 2018-03-09 12:14:56 4116 [ERROR] mysql.user: 1 个客户端正在使用或没有正确关闭表

Thank you.

谢谢你。

回答by Edmon Uyan

prior to running

跑步前

mysql_upgrade

do this first

先做这个

mysqlcheck --repair --all-databases