I Want to upgrade xampp mysql from 5.1 to 5.6.10 I installed mysql server to mysql path in xampp path but didn't work for me . do you have any idea or any way to upgrade mysql in xampp ?
Best Regards Ali
I have found the perfect way of doing it without any side effects and also works perfectly with the xampp control panel...
Before you begin, make sure you backup your databases to files and export all users to a file. Make sure to stop mysql, but there is no need to uninstall the service.
Step 1: Download the new version of MySQL install version or zip (install version preferred since it is considerably smaller)
Step 2: Install MySQL to C:\TEMP. Install only the MySQL server
Step 3: Do not run advance options. Do not let it install a service. No configuration is required.
Step 4: Go to C:\TEMP, look for installation and copy the following folders "bin, include, lib, share, support-files". be absolutely certain not to copy the data folder.
Step 5: Go to mysql_old and copy the data folder and paste it into your new mysql folder as well
Step 6: Go to the bin folder within mysql that is located within xampp and create a blank my.ini file. If you are upgrading to version 5.6.11 which is what I did, then all you have to do is write a few commands which I have at the bottom of this instruction
step 7: Click start next to MySQL on the xampp control panel and it should start normally assuming to you followed to instructions properly. Once done, you can uninstall the mysql package that you had installed to C:\TEMP.
Any questions or problems, message me or post back!
BY THE WAY, the key is having a proper my.ini file
here is mine:
I tried @Seul Shahkee 's solution, works fine but in my case I also copied over the my.ini file from the old bin folder over to the new mysql folder. Some configuration variables are no longer supported though it seems, so I simply commented them out and it seems to work.. so far.. No 100% guarantee though..