How to Update MySQL (MariaDB) in XAMPP Local Server

Learn with me How to Update Your MySQL (Upgrade MariaDB) in XAMPP. This is the Easiest and Secure Way for Update XAMPP in any Windows Version Step by Step XAMPP Tutorials for Beginners Installation, Upgrade and Apache error Solution (for Windows 7/8/10). Step №1. First for Security Backup Your MySQL Database. MariaDB upgrading Process Will Secure 100% Step №2. Download Mariadb Latest Version (zip file). Choose File with Your PC ability 32 or 64 bit Step №3. Stop Apache and MySQL in XAMPP Control Panel ( Stop All Services) Step №4. Rename MySQL Folder Name in c Drive Like This Folder Path C:\xampp\mysql_OLD Step №5. Extract downloaded mariadb.zip file in to XAMPP Folder and rearrange the folder path Step №6. Open xampp & xampp_OLD folder side by side Step №7. Rename this data folder as you like. I'll rename it like this: data_New_for-DEL Step №8. From left side Copy "data" folder(C:\xampp\mysql_OLD\data) to right side in (C:\xampp\mysql) Step №9. From left side Copy "backup" folder(C:\xampp\mysql_OLD\backup) to right side in (C:\xampp\mysql) Step №10. From left side Copy "scripts" folder (C:\xampp\mysql_OLD\backup) to right side in (C:\xampp\mysql) Step №11. From left side Copy this 2 files (mysql_installservice.bat and mysql_uninstallservice.bat ) to right side in (C:\xampp\mysql) Step №12. From left side Copy my.ini file(C:\xampp\mysql_OLD\bin) to right side in (C:\xampp\mysql\bin) Step №13. In right side make some change in "my.ini" file, (C:\xampp\mysql\bin) Make sure you have "#" sing before "skip-federated" Step №14. In right side Again edit "my.ini" file, Put this line of code "skip-grant-tables" anywhere and save Step №15. In right side Find "mysql.upgrade.exe" file (inC:\xampp\mysql\bin) and double click on it. it will update automatically. don't close black widow Step №16. In right side Again go to "my.ini" file, delete this line of code "innodb_additional_mem_pool_size = 2M" and save Step №17. In right side Now delete this folder "data_New_for-DEL" Step №18. In left side Now delete this folder "mysql_OLD" Congratulation! You Successfully Updated MySQL - MariaDB ============================================== MariaDB Download Link https://downloads.mariadb.org/ ============================================= Easily Update Your XAMPP Local Server for Windows 7 8 10 [Full Series ] There are Other XAMPP Tutorials Available Below: ...................................................................................... How to Update phpMyAdmin in XAMPP (№1) https://youtu.be/5GOJ6iihfcU How to Update PHP Version in XAMPP (№2) https://youtu.be/H9lM34NgULw How to Install XAMPP for Windows 7/8/10 and Configuration with Tomcat, Mercury and Filezilla (Full) [Update Nov. 2018] https://youtu.be/KUe1iqPH4iM ============================================== Follow Me with Your Favourite Social Media .................................................. https://www.facebook.com/webddss/ https://www.pinterest.com/webddss/ https://twitter.com/webddss https://plus.google.com/107689534727057416800 https://webddss.blogspot.com/ https://webddss.tumblr.com/ https://ask.fm/webddss https://mix.com/webddss https://www.flickr.com/photos/webddss https://www.buzzfeed.com/webddss https://www.quora.com/profile/Web-Ddss https://www.reddit.com/user/webddss #UpdateMySQL #UpgradeMySQL #XAMPPMySQL