Instalation problem

------=_Part_1181_21383810.1162271984782
Content-Type: text/plain; charset=UTF-8; format=flowed
Content-Transfer-Encoding: 7bit
Content-Disposition: inline

Dear All
I am trying to configure "mysql-4.0.18" on Windows 2003 server. When i run
\mysql-4.0.18\bin\winmysqladmin.exe, it runs but service fail to run and
always show red light. I tried to run the service from Control
Panel\Services\MySQL but i found a message "Could not start MySQL Service on
local computer Error 1067: The process terminated unexpectedly"

Regards,

Ata ur Rehman,

Librarian,
Akhter Hameed Khan Resource Center (AHKRC),
NRSP-Institute of Rural Management,
F-6/4, Islamabad

Ph: +92 51 2822752
+92 51 2822792

http://www.irm.edu.pk/

------=_Part_1181_21383810.1162271984782--

Re: Instalation problem

Dear Asif Lodhi Sb

Thank you very much for prompt response. I have adopted the method
you mentioned (For MySQL-5.0.27 ). And all is ok now. I dont know
about InnoDB as I am new to MySQL. Can you tell me about it? Have I
to download something else?

Regards,

Ata ur Rehman,

Librarian,
Akhter Hameed Khan Resource Center (AHKRC),
NRSP-Institute of Rural Management,
F-6/4, Islamabad

Ph: +92 51 2822752
+92 51 2822792

http://www.irm.edu.pk/

On 11/1/06, Asif Lodhi wrote:
> Hi Ata,
>
> Why don't you use MySQL-5.0.26? It has more features, speed and
> plenty of bug-fixes. Also, I would suggest that you use InnoDB engine.
>
> I got MySQL 5.0.2x running successfully on Win-XP-SP2 as follows -
> this procedure should work fine on Win-2003 as well:
>
> 1) Download the no-install zip package of MySQL-5.0.26 from the website.
> 2) Unpack it in the directory of your choice (C:\mysql5 - for
> example) - NOT in ProgramFiles!
> 3) Create a top-level folder - C:\mysql5Data for the data directory.
> 4) Cut the contents of C:\mysql5\data directory and paste the same
> into C:\mysql5Data.
> 5) Delete C:\mysql5\data directory.
> 6) Create a copy of an appropriate mysql-xxx.ini file and rename it to MY.INI.
> 7) Change the value of the data-dir variable to C:/mysql5Data - NOTE
> FORWARD INSTEAD
> OF BACK-SLASHES.
> 8) Create another top-level C:\InnoDBData folder.
> 9) Change appropriate InnoDB data-directory variables in C:\my.ini
> (with forward slashes!)
> 10) Right-click MY COMPUTER icon on the desktop and select properties
> from the shortcut
> menu. Goto the Advanced tab and select Environment [Variables].
> Select PATH in the \
> system variables and add C:\mysql5\bin; at the beginning of it.
> Apply and OK.
> 11) Right click the C:\InnoDBData folder, select Properties from the
> shortcut menu and
> add "LOCAL SERVICE" user-account in the security tab and give it
> "Full Control" access.
> 12) Do the same as in 12) with the C:/mysql5Data folder.
> 13) Select RUN from the start menu, type CMD and press ENTER.
> 12) type at command-line: mysqld-nt --install YourServiceName
> --defaults-file=C:\mysql5\my.ini --local-service
> and press ENTER.
> 13) type NET START YourServiceName AND PRESS ENTER.
>
> Now you have MYSQL-5.0.22 installed & running on WinXP-Pro-SP2.
>
> Forget about the automatic installer. I got similar errors like yours.
>
> Additionally, I have found that the MySQL ODBC driver installs best
> when you do it manually - that is, hand-copy files into the Windows
> System32 directory. In addition, as I have found, it complains that
> some MSVCR7.dll is missing. When I searched for the file on Google,
> the search engine led me to some DllFiles.com (or some similar
> webpage) where I got the file, downloaded the same to my computer, put
> it in the system32 directory and
> everything worked like a cinch!
>
> --
> Asif
>
>
> On 10/31/06, Ata ur Rehman wrote:
> > Dear All
> > I am trying to configure "mysql-4.0.18" on Windows 2003 server. When i run
> > \mysql-4.0.18\bin\winmysqladmin.exe, it runs but service fail to run and
> > always show red light. I tried to run the service from Control
> > Panel\Services\MySQL but i found a message "Could not start MySQL Service on
> > local computer Error 1067: The process terminated unexpectedly"
>

--
MySQL Windows Mailing List
For list archives: http://lists.mysql.com/win32
To unsubscribe: http://lists.mysql.com/win32?unsub=gcdmw-win32@m.gmane.org