Virif

Search Content

programming featured

Upgrade xampp in windows? a complete solution.

I couldn’t find any complete solution to help people out with updating XAMPP in Windows. So, finally here is an easy to understand, step by step guide to upgrade XAMPP that actually works.

major changes!

If you are upgrading xampp after a long time like me than be ready for some major changes. XAMPP no longer comes with the MySQL server. Since XAMPP 5.5.30 and 5.6.14, XAMPP ships MariaDB instead of MySQL. So copy pasting the mysql data files from old to new xampp won’t work anymore!

main difficulties!

While upgrade xampp, we basically face 2 challenges

  1. Moving all the site files. This portion is easy, just a simple copy paste will do the trick.
  2. Moving all the databases to the new server. And most often this is the main reason why most people do not update XAMPP very often. Cause backing up all the databases one by one and then importing them to the new server is a long and really boring task.

let’s start the complete solution:

Follow the steps below and your XAMPP will be updated in no time!

backup your old data first in 7 easy steps!

Lets backup all the databases first

  1. Open XAMPP Control Panel as an Administrator
  2. Click on the Shell option
  3. run the following command mysqldump -u root -p --all-databases > all-db-dump.sql
  4. If you have different user for databases then change the value ‘root’ with username. If you don’t have any password just press enter. Otherwise provide the password.
  5. This will create a SQL file named “all-db-dump.sql” that contains all the databases in MySQL server. You will find this file in xampp folder.
  6. Now stop both Apachee and MySQL servers and quit the xampp control panel. Close the command prompt too.
  7. Now rename your ‘xampp’ folder to ‘xampp-old’. This way if anything goes wrong you will be able to get back to the old version very easily.

time to install new XAMPP Server and restore your backup files and database!

  1. Download the latest version of XAMPP.
  2. Install it in the same drive where your old Xampp originally was.
  3. Now go to xampp folder and run the xampp control panel as Administrator.
  4. Start both Apachee and MySQL server and check whether they are working properly or not, also check PhpMyAdmin page.
  5. Now Copy the htdocs folder from ‘xampp-old’ folder to ‘xampp’ folder.
  6. Go to xampp\php\php.ini
  7. You can use CLI for importing database. It helps especially with very big databases. If so you can jump to step 19. If not follow the remaining steps.
  8. Now configure the php.ini file and increase the value for the following options upload_max_filesize,memory_limit, post_max_size .
  9. post_max_size and memory_limit need to be larger than upload_max_filesize. Make them high enough so big files can work on the server.
  10. Go to ‘xampp\phpMyAdmin\libraries\config.default.php’
  11. Look for $cfg[‘ExecTimeLimit’] = 600;
  12. Change the value 600 to a higher value may be 6000.
  13. Now restart both Apache and MySQL server.
  14. Now go to phpMyAdmin
  15. Go to Import tab
  16. Import ‘all-db-dump.sql’ file through the import option directly to server.
  17. Based on how many databases you have it will take some time.
  18. If you have followed all the steps correctly you will get a success message “ Import has been successfully finished”.
  19. After that run the following command mysql_upgrade in the Shell option.
  20. Go ahead and check whether your site and databases are working properly or not.
  21. If everything is working fine than you can delete the xampp-old file.

 

If you have followed my instructions then you should have a functioning XAMPP with no issues. If you do face any problem leave a comment and I will do my best to get back to you.

Note: If you do not want to upgrage only PHP version  you can follow this link

Post Views: 726