XAMPP

XAMPP(all old version and latest version of XAMPP files)

Roll back to the old version of MySQL at XAMPP

Method1: use the same name for old version of MySQL folder

1. stop the ongoing MySQL service
2. move the new version of MySQL to different holder ex: move C:/mysql to C:/mysql_new
3. move the old version of MySQL to original holder ex: move C:/mysql_old to C:/mysql

Modify the configuration of MySQL(optional)

modify the path of basedir, datadir, Server in MySQL conf file: %windir%\my.ini or {xampp}\mysql\data\my.ini

[mysqld]
basedir=C:/mysql_old
datadir=C:/mysql_old/data

log-error=C:/mysql_old/data/mysql-error.log

log-slow-queries = C:/mysql_old/data/mysql-slow.log
long_query_time = 5
log-long-format

[WinMySQLadmin]
Server=C:/mysql_old/bin/mysqld-nt.exe

Modify the path of MySQL service

HKEY_LOCAL_MACHINE\SYSTEM\ControlSet001\Services\mysql\ImagePath

• original: "C:\Program Files\xampp\mysql\bin\mysqld-nt.exe" "--defaults-file=C:\Program Files\xampp\mysql\bin\my.cnf" mysql
• old version: "C:\mysql_old\bin\mysqld-nt.exe" "--defaults-file=C:\mysql_old\bin\my.cnf" mysql

restart the MySQL service

Troubleshottings

• Could not link to the localhost after executed the xampp_start.exe! [XAMPP Lite 1.6.3a]
  • Check the port (execute the file: xampp-portcheck.exe )! Port 80 was occupied by some softwares, such as
    • Skype
    • Gladinet Cloud Desktop
  • Check the AntiVirus software (ex: Pause the Nod32) and security settings!

• Could not launch xampp (xampp_start.exe) after moved the xampp files to new file location [XAMPP Lite 1.7.3]ex
  • solution: execute the file: setup_xampp.bat to relocate the xampp

upgrade xampp

• re-check the installation file path of xampp in the conf files of Apache, PHP, Mysql (ex: xampp was installed at d:\xampp, the conf files was written as d:d:\xampp) [XAMPP v1.7.5]
  • filezilla server: {xampp}\FileZillaFTP\FileZilla Server.xml
• Move the folder of old PHP extension files and install new one after installed new version of XAMPP. Else the folder of PHP extension files will not be overwrote during the installation. The missing PHP extension will cause Apache starting-problems