List:MySQL on Win32« Previous MessageNext Message »
From:Jorge Bastos Date:December 29 2005 10:14pm
Subject:Fw: Error 1067
View as plain text  
mysql conf file can be one of:
%WINDIR%\my.ini
%WINDIR%\my.cnf
"MYSQL_PLACE\data\my.ini"
"MYSQL_PLACE\data\my.cnf"



----- Original Message ----- 
From: "Lawson Cronlund" <lawson@stripped>
To: <lucky-joe@stripped>; "'Jorge Bastos'" <mysql.jorge@stripped>; 
<win32@stripped>
Sent: Thursday, December 29, 2005 7:10 PM
Subject: RE: Error 1067


I think there's been some confusion about differences between the Linux
version of MySQL and the Windows version.  I'll offer what I hope is
clarification for what I've noticed on this particular thread.  Where I'm
wrong, please let me know so that I can improve my knowledge about the MySQL
system.

1.  my.ini location
-------------------

The my.ini file is the windows equivalent of the Linux my.cnf file.  There
is a search procedure to find it but it's normally stored in the MySQL
installation directory on windows systems. On my installation of MySQL
5.0.15 this is: "C:\Program Files\MySQL\MySQL Server 5.0".

This is not a directory that Linux has (normally) so the Linux location will
be different.  I think that location has been reported already.

2.  Nested directory name delimiters
------------------------------------

My experience with the windows version of the MySQL system is that every
attempt has been made by MYSQL AB to retain commonality for the textual
files (e.g. my.ini and my.cnf) between the different platforms.  My
experience has been that the forward slashes are used in files like my.ini
and the MYSQL developers incorporated conversion to the Windows back slashes
into the application programs that read the file.  The my.ini file on my
Windows XP MySQL 5.0 installation contains the line:

datadir="C:/Program Files/MySQL/MySQL Server 5.0/Data/"

This works.  There are no back slashes anywhere in the file.



I think this was a good decision on the part of MYSQL AB since it allows
people who know the MySQL system to review settings independent of platform
in most cases.

Regards.




Lawson
lawson@stripped
+1(480)308-0641 (Voice)
+1(602)996-0376 (Fax)


-----Original Message-----
From: Joe's Mail [mailto:lucky-joe@stripped]
Sent: Thursday, December 29, 2005 4:37 AM
To: Jorge Bastos; win32@stripped
Subject: AW: Error 1067


Hi Jorge,

It does not work, the same problem, the service does not start anymore,
furthermore the pathes in the my.ini-file are written in unix-style with
slashes and not with backslashes, so I don't think that this is the problem.


Joe

-----Ursprüngliche Nachricht-----
Von: Jorge Bastos [mailto:mysql.jorge@stripped]
Gesendet: Donnerstag, 29. Dezember 2005 12:22
An: win32@stripped
Betreff: Fw: Error 1067

Joe,

You have to use \\ in directories, the slash's have to be in double always,
because \s \c \p or /s /c /p will be escape caracters
"C:\\Programme\\MySQL\\MySQL Server 5.0"

like this



----- Original Message -----
From: "Joe's Mail" <lucky-joe@stripped>
To: "LE Backup" <lucretias@stripped>; <win32@stripped>
Sent: Thursday, December 29, 2005 11:15 AM
Subject: AW: Error 1067


> Hi James,
>
> Could there be a problem with the white-spaces in the path-names or so ?
>>Where is you're my.ini installed?
> The my.ini file ist in the installation-directory C:\Programme\MySQL\MySQL
> Server 5.0 .
>
>
>>What settings do you have in this my.ini?
> I have installed the server with the setup-wizard and configured it with
> the
> config-wizard.
>
> [client]
> port=3306
> [mysql]
> default-character-set=latin1
> [mysqld]
> # The TCP/IP Port the MySQL Server will listen on
> port=3306
> basedir="C:/Programme/MySQL/MySQL Server 5.0/"
> datadir="C:/Programme/MySQL/MySQL Server 5.0/Data/"
> default-character-set=latin1
>
>>Do you also have a my.cnf file?
> No I don't have
>
>
>>Ensure you only have one copy, and ideally it should be in your Apache/Bin
>>directory.
> Why should it be in the apache-dir ?
>
>
> Cheers.
>
> James Friesen, CIO
>
> Lucretia Enterprises
> "Our World Is Here..."
> Info at lucretia dot ca
> http://lucretia.ca
>
>
>> -----Original Message-----
>> From: Joe's Mail [mailto:lucky-joe@stripped]
>> Sent: Wednesday, December 28, 2005 10:05 AM
>> To: win32@stripped
>> Subject: Error 1067
>>
>> Hi at all,
>>
>> I have problem to start the MySql-Server as a service under
>> Windows XP-Home.
>> The installation was sucessfully finished but when I will
>> start the server as a service, it will termiated with the error 1067.
>>
>> Does anybode know what will going wrong ?
>>
>> t.i.a
>> Joe
>>
>>
>> --
>> MySQL Windows Mailing List
>> For list archives: http://lists.mysql.com/win32
>> To unsubscribe:
>> http://lists.mysql.com/win32?unsub=1
>>
>
>
>
> --
> MySQL Windows Mailing List
> For list archives: http://lists.mysql.com/win32
> To unsubscribe:    http://lists.mysql.com/win32?unsub=1
>
>
> --
> MySQL Windows Mailing List
> For list archives: http://lists.mysql.com/win32
> To unsubscribe:
> http://lists.mysql.com/win32?unsub=1
>
>



--
MySQL Windows Mailing List
For list archives: http://lists.mysql.com/win32
To unsubscribe:    http://lists.mysql.com/win32?unsub=1


-- 
MySQL Windows Mailing List
For list archives: http://lists.mysql.com/win32
To unsubscribe:    http://lists.mysql.com/win32?unsub=1



Thread
Fw: Error 1067Jorge Bastos29 Dec