XAMPP: Difference between revisions
Jump to navigation
Jump to search
m (→upgrade xampp) |
|||
| Line 8: | Line 8: | ||
basedir=C:/mysql_old | basedir=C:/mysql_old | ||
datadir=C:/mysql_old/data | 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] | [WinMySQLadmin] | ||
Revision as of 10:51, 22 March 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 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!
- Check the port (execute the file: xampp-portcheck.exe )! Port 80 was occupied by some softwares, such as
- 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