14,954
edits
XAMPP: Difference between revisions
Jump to navigation
Jump to search
→Roll back to the old version of MySQL at XAMPP
| Line 6: | Line 6: | ||
# move the new version of MySQL to different holder ex: move C:/mysql to C:/mysql_new | # move the new version of MySQL to different holder ex: move C:/mysql to C:/mysql_new | ||
# move the old version of MySQL to original holder ex: move C:/mysql_old to C:/mysql | # move the old version of MySQL to original holder ex: move C:/mysql_old to C:/mysql | ||
# restart the MySQL service | |||
=== Method2: use the different name for old version of MySQL folder === | === Method2: use the different name for old version of MySQL folder === | ||
=== Modify the configuration of MySQL(optional) === | ==== Modify the configuration of MySQL(optional) ==== | ||
modify the path of basedir, datadir, Server in [http://www.mysql.com/ MySQL] conf file: %windir%\my.ini or {xampp}\mysql\data\my.ini | modify the path of basedir, datadir, Server in [http://www.mysql.com/ MySQL] conf file: %windir%\my.ini or {xampp}\mysql\data\my.ini | ||
<pre> | <pre> | ||
| Line 26: | Line 26: | ||
</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 | ||