I am going to share a complete solution to help people out with updating XAMPP in Windows. Let's start step by step guide to upgrade XAMPP that actually works!

While updating XAMPP we basically face few challenges like - 


  1. Moving all the site files from xampp folder. 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 issue why we don’t update XAMPP very often. Cause backing up all the databases one by one and then importing them to new server is really a long boring work.

Now Follow the following steps!

BACKUP OLD DATA!

Lets backup all the databases from xampp,
  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-backup.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-backup.sql” that contains all the databases in MySQL server. You will find this file in xampp folder.
  6. Now stop both Apache 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.


NOW INSTALL THE NEW XAMPP!


  1. Download the latest version of XAMPP.
  2. Install it in the same drive where your old xampp currently installed.
  3. Now 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 specially helps 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’] = 800;
  12. Change the value 800 to a higher value may be 8000.
  13. Now restart both Apache and MySQL server.
  14. Now go to phpMyAdmin then Go to Import tab
  15. Import ‘all-db-dump-backup.sql’ file through the import option directly to server.
    Based on how many databases you have it will take some time.
  16. If you have followed all the steps correctly you will get a success message “ Import has been successfully finished”.
  17. After that run the following command mysql_upgrade in the Shell option.
  18. Go ahead and check whether your site and databases are working properly or not.
  19. 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 then please leave a comment and I will do my best to get back to you.  Enjoy!!
 

How to upgrade XAMPP in Windows? PHP 5 to 7 version

Sangwan Pankaj Reply 15:26

I am going to share a complete solution to help people out with updating XAMPP in Windows. Let's start step by step guide to upgrade...

In this tutorial, i will share how to send Email from XAMPP (PHP). i use XAMPP 1.8.1 version .This has been tested by me and it worked.

Lets start:-
first always make a backup before changing any code in core/configuration files.
then

Edit your php.ini in - “xampp\php\php.ini”

Before Changes:- 
---------------------------
[mail function]
; For Win32 only.
; http://php.net/smtp
SMTP = localhost
; http://php.net/smtp-port
smtp_port = 25

; For Win32 only.
; http://php.net/sendmail-from
;sendmail_from = postmaster@localhost

; XAMPP IMPORTANT NOTE (1): If XAMPP is installed in a base directory with spaces (e.g. c:\program filesD:\xampp) fakemail and mailtodisk do not work correctly.
; XAMPP IMPORTANT NOTE (2): In this case please copy the sendmail or mailtodisk folder in your root folder (e.g. C:\sendmail) and use this for sendmail_path.

; XAMPP: Comment out this if you want to work with fakemail for forwarding to your mailbox (sendmail.exe in the sendmail folder)
;sendmail_path = "\"\XAMPP\sendmail\sendmail.exe\" -t"

After Changes :-
-----------------------
[mail function]
; For Win32 only.
; http://php.net/smtp
SMTP = smtp.gmail.com
; http://php.net/smtp-port
smtp_port = 587

; For Win32 only.
; http://php.net/sendmail-from
sendmail_from = yourgmailid@gmail.com

; XAMPP IMPORTANT NOTE (1): If XAMPP is installed in a base directory with spaces (e.g. c:\program filesD:\xampp) fakemail and mailtodisk do not work correctly.
; XAMPP IMPORTANT NOTE (2): In this case please copy the sendmail or mailtodisk folder in your root folder (e.g. C:\sendmail) and use this for sendmail_path.

; XAMPP: Comment out this if you want to work with fakemail for forwarding to your mailbox (sendmail.exe in the sendmail folder)
sendmail_path = "\"\XAMPP\sendmail\sendmail.exe\" -t"

now

Edit your sendmail.ini - “xampp\sendmail\sendmail.ini”

smtp_server=mail.mydomain.com or smtp_server=localhost

; smtp port (normally 25)
smtp_port=25

comment these two lines using - ;


;smtp_server=mail.mydomain.com or ;smtp_server=localhost
; smtp port (normally 25)

;smtp_port=25



and add some extra code in the bottom of your sendmail,ini:

;new config:
smtp_server=smtp.gmail.com
smtp_port=587
smtp_ssl=tls
error_logfile=error.log
pop3_server=
pop3_username=
pop3_password=
force_recipient=
hostname=
auth_username=yourgmailid@gmail.com
auth_password=your gmail password
force_sender=yourgmailid@gmail.com

NOTE: 
  1. You Need to restart xampp after saving both files.
  2. Change yourgmailid@gmail.com & your gmail password  with your own email id and password
  3. You Need to enable SMTP in your GMail to make this work and all sender will be from your email (if need).





Enable Send Email in XAMPP (localhost)

Sangwan Pankaj Reply 11:27

In this tutorial, i will share how to send Email from XAMPP (PHP). i use XAMPP 1.8.1 version .This has been tested by me and it worked. L...

Copyright by GhostPHP. Powered by Blogger.

Search

Recent Post

Popular Posts

Follow us