problem when trying to start MySQL on windows server XP

problem when trying to start MySQL on windows server XP

Post by Ken Menze » Sun, 31 Mar 2002 00:36:34



Hello Jos,
   I will try this.  Error 1067 is "an invalid Default value".    One
problem I see is you are starting mysql from the C: and telling it it
is installed on e:.  Perhaps you only wanted to move the data
directory?  In that case use the --datadir or my.cnf with the date dir
set to e:\mysql.

En autre il y a un liste en fran?ais si ?a t'interesse :
Liens utils :




Amicalement,
Ken

----- Original Message -----


Sent: Friday, March 29, 2002 8:13 AM
Subject: problem when trying to start MySQL on windows server XP

> Hello,

> I try to install MySQL on Windows XP (Enterprise server). I have 3
hard-disk
> : C: ,formated on windows 95 fat, D: and E: formated on XP FAT. I
need to
> install MySQL on XP, disk E . I'd first installed mySQL on C:. Then
I
> created a file my.cnf with the following information :
"Basedir=e:/mysql/"
> (folder where i'd re-installed my SQL) and stored it on c:.
> Then I typed the command : "c:\mysql\bin\mysqld-nt --basedir
E:\mysql".
> when I try to start MySQL ("Net start mysql") I have following the
message :

> - le service MySQL demarre
> - le service MySQL n'a pu tre lanc
> - une erreur system s'est produite
> - l'erreur 1067 s'est produite
> - le processus s'est arret inopinment

> How can solve this problem ?

>             Thank you for your reply.

>                             M. Blanch jos

______________________________________________________________________
________
> ifrance.com, l'email gratuit le plus complet de l'Internet !
> vos emails depuis un navigateur, en POP3, sur Minitel, sur le WAP...
> http://www.ifrance.com/_reloc/email.emailif

> --------------------------------------------------------------------
-
> Before posting, please check:
>    http://www.mysql.com/manual.php   (the manual)
>    http://lists.mysql.com/           (the list archive)


> To unsubscribe, e-mail


Quote:> Trouble unsubscribing? Try:

http://lists.mysql.com/php/unsubscribe.php

---------------------------------------------------------------------
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/           (the list archive)



Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

 
 
 

1. Changing the server that is started by entry in Services in Windows XP?

Hi All,

I recently downloaded and installed MySQL-3.23.55 for Windows XP.

Previously I was running MySQL-3.23.53-max-nt, but now the Service entry
that appears under the Services List under Administrative Tools runs
3.23.55-nt when started, when I would prefer it to run 3.23.55-max or
3.23.55-max-nt. I can't seem to edit the server this Service runs by
clicking on its properties in the Services List.

Can anyone tell me how I change which version of the server this Service
runs when started?

Following is the information from my my.ini file, if that's helpful. It
certainly lists mysql-max.exe, but appears that's not what gets started
when I start the service.

#This File was made using the WinMySQLAdmin 1.4 Tool
#29/01/2003 9:39:14 PM

#Uncomment or Add only the keys that you know how works.
#Read the MySQL Manual for instructions

[mysqld]
basedir=C:/mysql
#bind-address=169.254.82.163
datadir=C:/mysql/data
#language=C:/mysql/share/your language directory
#slow query log#=
#tmpdir#=
port=3306
#set-variable=key_buffer=16M
[WinMySQLadmin]
Server=C:/mysql/bin/mysqld-max.exe
user=[withheld]
password=[withheld]

Regards and best wishes,

Murray Wells

---------------------------------------------------------------------
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/           (the list archive)



Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

2. Dial-up hangs occasionally

3. OEM Office XP, Windows XP, & Adobe, Windows on Sale Now

4. Mondays Surrey and Sussex meeting

5. Minimial settings on Windows XP AND Linux for MySQL server

6. 32 MB RAM in a 2514: Possible?

7. postgres service starts then stops on Windows XP Home

8. Switching to Outlook Express and ACT!

9. Foreign key problems with MySQL 4.0.12 on Windows XP

10. problem to stop mysql under windows xp

11. Problem with windows XP and mysql

12. 5 Windows XP + 6 Office XP = $80 x b

13. 0 Windows XP + 0 Office XP = $80 b yy vvxz