Installing mysql as a service from a drive other than C:
Posted: 25. March 2009 03:03
Version: xampplite 1.7.0.
I've been really suffering from this one for quite a while: Basically I unzipped xampplite to D:\ and installed mysql as a service via xampp-control.exe.
Running with start/stop wasn't a problem, but once I installed it as a service it went all buggy, issuing "System error 1067 has occurred" over and over again...
xampplite is [supposed to be] designed to work from ANY drive, provided that it's installed directly under the root of the drive.
Well, after A LOT of trial and error, I found out that xampplite/mysql/bin/my.cnf contains several lines similar to the following:
basedir="/xampplite/mysql"
By changing all
"/xampplite/mysql"
occurrences to an absolute path such as this:
"d:/xampplite/mysql"
I finally got it to work!
So in case you're having similar issues with error 1067 - that's one step in solving the horrid error no. 1067.
NOTE: Investigating a bit deeper I found out that if I have a copy of xampplite under my C:\ root,
then everything will run just fine **from my d:\xampplite installation** even if I don't add the drive letter to "d:/xampplite/mysql", rather leave it like this: "/xampplite/mysql".
Going the extra mile, I then renamed C:\xampplite to something else, and again - everything broke down and I got error 1067 once again.
My conclusion is that when mysql works with non-absolute paths, it implicitly assumes that the active drive is C: and not the current one.
This took me DAYS to realize, so I hope it'll save the time for anyone reading this post.
Also - I hope the developers will see this post and take it under consideration in future versions.
(*) Actually, I'd like to mention another error that drove me crazy when I installed mysql as a service. This was related to the fact that when running mysql for the first time, a .ini file is created with a line that tried to execute "mysqld-shareware.exe".
This file doesn't exist and so the line needs to be replaced to execute "mysqld.exe" instead (I can't remember the exact details on how to fix).
-- SkyDiver
I've been really suffering from this one for quite a while: Basically I unzipped xampplite to D:\ and installed mysql as a service via xampp-control.exe.
Running with start/stop wasn't a problem, but once I installed it as a service it went all buggy, issuing "System error 1067 has occurred" over and over again...
xampplite is [supposed to be] designed to work from ANY drive, provided that it's installed directly under the root of the drive.
Well, after A LOT of trial and error, I found out that xampplite/mysql/bin/my.cnf contains several lines similar to the following:
basedir="/xampplite/mysql"
By changing all
"/xampplite/mysql"
occurrences to an absolute path such as this:
"d:/xampplite/mysql"
I finally got it to work!
So in case you're having similar issues with error 1067 - that's one step in solving the horrid error no. 1067.
NOTE: Investigating a bit deeper I found out that if I have a copy of xampplite under my C:\ root,
then everything will run just fine **from my d:\xampplite installation** even if I don't add the drive letter to "d:/xampplite/mysql", rather leave it like this: "/xampplite/mysql".
Going the extra mile, I then renamed C:\xampplite to something else, and again - everything broke down and I got error 1067 once again.
My conclusion is that when mysql works with non-absolute paths, it implicitly assumes that the active drive is C: and not the current one.
This took me DAYS to realize, so I hope it'll save the time for anyone reading this post.
Also - I hope the developers will see this post and take it under consideration in future versions.
(*) Actually, I'd like to mention another error that drove me crazy when I installed mysql as a service. This was related to the fact that when running mysql for the first time, a .ini file is created with a line that tried to execute "mysqld-shareware.exe".
This file doesn't exist and so the line needs to be replaced to execute "mysqld.exe" instead (I can't remember the exact details on how to fix).
-- SkyDiver