Upgrade XAMPP in Windows

I had to write this article cause I couldn’t find any complete solution to help people out with updating XAMPP in Windows. Well, finally here is a easy to understand, step by step guide to upgrade XAMPP that actually works. Kudos!

SOME MAJOR CHANGES!

If you are updating 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!

THE CHALLENGES!

While updating 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 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.

THE COMPLETE SOLUTION:

Follow the following steps and you will be there in no time!

BACKUP OLD DATA!

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.

LETS INSTALL THE NEW ONE!

  1. Download the latest version of XAMPP.
  2. Install it in the same drive where your old xampp currently is.
  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. Now configure the php.ini file and increase the value for the following options upload_max_filesize,memory_limit, post_max_size .
  8. 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.
  9. Go to ‘xampp\phpMyAdmin\libraries\config.default.php’
  10. Look for $cfg[‘ExecTimeLimit’] = 600;
  11. Change the value 600 to a higher value may be 6000.
  12. Now restart both Apache and MySQL server.
  13. Now go to phpMyAdmin
  14. Go to Import tab
  15. Import ‘all-db-dump.sql’ file through the import option directly to server.
  16. Based on how many databases you have it will take some time.
  17. If you have followed all the steps correctly you will get a success message “ Import has been successfully finished”.
  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.

 

SOURCE: https://medium.com/@asif.rocks/how-to-upgrade-xampp-in-windows-the-easy-way-93031fc923ce

Permissões para escrever numa pasta no IIS 7.5

Giving write permissions to all IIS_USRS group is a bad idea from the security point of view. You dont need to do that and you can go with giving permissions only to system user running the application pool.

If you are using IIS7 (and I guess you do) do the following.

  1. Open IIS7
  2. Select Website for which you need to modify permissions
  3. Go to Basic Settings and see which application pool you’re using.
  4. Go to Application pools and find application pool from #3
  5. Find system account used for running this application pool (Identity column)
  6. Navigate to your storage folder in IIS, select it and click on Edit Permissions (under Actions sub menu on the right)
  7. Open security tab and add needed permissions only for user you identified in #3

 

Note #1: if you see ApplicationPoolIdentity in #3 you need to reference this system user like this IIS AppPool\{application_pool_name} . For example IIS AppPool\DefaultAppPool

Note #2: when adding this user make sure to set correct locations in the Select Users or Groups dialog. This needs to be set to local machine because this is local account.

 

SOURCE: http://stackoverflow.com/a/14654062

Update node.js + npm on Windows

The new best way to upgrade NPM on Windows:

https://github.com/felixrieseberg/npm-windows-upgrade

Run PowerShell as Administrator

Set-ExecutionPolicy Unrestricted -Scope CurrentUser -Force
npm install -g npm-windows-upgrade
npm-windows-upgrade

Note: Do not run npm i -g npm. Instead use npm-windows-upgrade to update npm going forward. Also if you run the NodeJS installer, it will replace the node version.

  • Upgrades npm in-place, where node installed it.
  • Easy updating, update the to the latest by running npm-windows-upgrade -p -v latest.
  • Does not modify the default path.
  • Does not change the default global package location.
  • Allows easy upgrades and downgrades.
  • Officially recommended by the NPM team.

 

Source: http://stackoverflow.com/questions/18412129/how-do-i-update-node-and-npm-on-windows

Como configurar um servidor NAT de encaminhamento e acesso remoto

Quando os clientes da rede interna enviam um pedido para a Internet, o controlador do protocolo NAT intercepta o pedido e reenvia-o para o servidor da Internet de destino. Todos os pedidos parecem ter origem no endereço IP externo do servidor NAT. Este processo oculta o esquema de endereços IP internos.

Para configurar um servidor NAT de encaminhamento e acesso remoto:

  1. No menu Ferramentas administrativas (Administrative Tools), clique em Encaminhamento e acesso remoto (Routing and Remote Access).
  2. Na MMC Encaminhamento e acesso remoto (Routing and Remote Access) expanda nome_do_servidor (em que nome_do_servidor é o nome do servidor que pretende configurar) e, em seguida, expanda Encaminhamento IP (IP Routing) no painel esquerdo.
  3. Clique com o botão direito do rato em Geral (General) e, em seguida, clique em Novo protocolo de encaminhamento (New Routing Protocol).
  4. Clique para seleccionar a caixa de verificação NAT/Firewall básico (NAT/Basic Firewall) e, em seguida, clique em OK.
  5. Clique com o botão direito do rato em NAT/Firewall básico (NAT/Basic Firewall) no painel esquerdo e, em seguida, clique em Nova interface (New Interface).
  6. Clique na interface que representa a interface da rede interna e, em seguida, clique em OK.
  7. Em Propriedades de tradução de endereços de rede (Network Address Translation Properties), clique em Interface privada ligada a uma rede privada (Private interface connected to private network) e, em seguida, clique em OK.
  8. Clique com o botão direito do rato em NAT/Firewall básico (NAT/Basic Firewall) no painel esquerdo e, em seguida, clique em Nova interface (New Interface).
  9. Clique na interface que representa a interface da rede externa e, em seguida, clique em OK.
  10. Em Propriedades de tradução de endereços de rede (Network Address Translation Properties), clique em Interface pública ligada à Internet (Public interface connected to the Internet).
  11. Clique para seleccionar a caixa de verificação Activar NAT nesta interface (Enable NAT on this interface) e, em seguida, clique em OK.

O servidor NAT pode atribuir automaticamente endereços IP a clientes da rede interna. Poderá pretender utilizar esta funcionalidade se não tiver um servidor de DHCP que já esteja a atribuir informações de endereçamento a clientes na rede interna.

 

Fonte: http://support.microsoft.com/kb/324264/pt

Windows 2003 Server perdeu partilha

Se a tab Partilha desapareceu das propriedades das pastas, deve-se verificar se os serviços Servidor e Browser do Computador estão activos.

Se mesmo assim não funcionar, tentar executar (Start -> Run)

"regsvr32 rshx32.dll"