XAMPP: Difference between revisions

From LemonWiki共筆
Jump to navigation Jump to search
No edit summary
No edit summary
Line 1: Line 1:
Roll back to the old version of [http://www.mysql.com/ MySQL] at [http://www.apachefriends.org/en/xampp.html XAMPP](all old version and latest version XAMPP [http://sourceforge.net/projects/xampp/files/ files])
[http://www.apachefriends.org/en/xampp.html XAMPP](all old version and latest version of XAMPP [http://sourceforge.net/projects/xampp/files/ files])


== Modify the configuration of MySQL(optional) ==
== Roll back to the old version of [http://www.mysql.com/ MySQL] at XAMPP ==
modify the path of basedir, datadir, Server in %windir%\my.ini
=== Modify the configuration of MySQL(optional) ===
modify the path of basedir, datadir, Server in [http://www.mysql.com/ MySQL] conf file: %windir%\my.ini
<pre>
<pre>
[mysqld]
[mysqld]
Line 12: Line 13:
</pre>
</pre>


== Modify the path of MySQL service ==
=== Modify the path of MySQL service ===
HKEY_LOCAL_MACHINE\SYSTEM\ControlSet001\Services\mysql\ImagePath
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
* original: "C:\Program Files\xampp\mysql\bin\mysqld-nt.exe" "--defaults-file=C:\Program Files\xampp\mysql\bin\my.cnf" mysql

Revision as of 16:33, 29 February 2012

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

Roll back to the old version of MySQL at XAMPP

Modify the configuration of MySQL(optional)

modify the path of basedir, datadir, Server in MySQL conf file: %windir%\my.ini

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

[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. The missing PHP extension will cause Apache starting-problems