CODEWITHSUNDEEP
phpdatabasexamppmariadb
silentcoder
silentcoder

Reputation: 1038

Update xampp from maria db 10.1 to 10.2

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

Current version is 10.1.19-MariaDB

Upvotes: 41

Views: 49449

Answers (7)

SuperMark
SuperMark

Reputation: 21

Please follow this process

  1. Clean shutdown
  2. cd C:\xampp\mysql\bin
  3. mysqladmin -uroot shutdown
  4. cd\
  5. Backup mysql
  6. rename C:\xampp\mysql to C:\xampp\mysql_10.4
  7. extract mariadb-10.8.3-winx64.zip (extract here to prevent duplicate folder)
  8. rename mariadb-10.8.3-winx64 to mysql
  9. copy mysql folder from zip to C:\xampp\
  10. Copy the following from mysql_10.4 to mysql
\bin\my.ini
\backup
\data\
\scripts\
\*.*
  1. Start mysql in xampp control panel
  2. cd C:\xampp\mysql\bin
  3. mysqlcheck -uroot --repair --all-databases
  4. mysql_upgrade.exe
  5. stop start mysql in xampp

Upvotes: 2

kanine
kanine

Reputation: 65

I generally use a simpler method, which is to install a new version of xampp on a separate computer. Then copy the installed mysql folder over and replace the data folder with the previous version.

Then run "C:\xampp\mysql\bin\mysql_upgrade.exe"

Upvotes: 0

edmoncuaft
edmoncuaft

Reputation: 91

  1. Shutdown MySQL in your XAMPP server from Xampp control panel or mysql under Services if it was added.
  2. Download the ZIP version of MariaDB (https://downloads.mariadb.org/) - you may download the winx64.zip if you are also switching to x64 variant 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-10.3.14-winx64, to mysql
  6. Rename xampp/mysql/data to data_temp
  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

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

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

  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)

Upvotes: 8

Edmon Uyan
Edmon Uyan

Reputation: 1

prior to running

mysql_upgrade

do this first 

mysqlcheck --repair --all-databases

Upvotes: 0

Vladan Ulardzic
Vladan Ulardzic

Reputation: 29

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.

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

Thank you.

Upvotes: 0

Sumit
Sumit

Reputation: 1802

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.

Upvotes: 126

Rana Hussain
Rana Hussain

Reputation: 489

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.

Upvotes: 31

Related Questions