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
[email protected]
+1(480)308-0641 (Voice)
+1(602)996-0376 (Fax)
 

-----Original Message-----
From: Joe's Mail [mailto:[email protected]] 
Sent: Thursday, December 29, 2005 4:37 AM
To: Jorge Bastos; [email protected]
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:[email protected]]
Gesendet: Donnerstag, 29. Dezember 2005 12:22
An: [email protected]
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" <[email protected]>
To: "LE Backup" <[email protected]>; <[email protected]>
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:[email protected]]
>> Sent: Wednesday, December 28, 2005 10:05 AM
>> To: [email protected]
>> 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/[email protected]
>>
>
>
>
> --
> MySQL Windows Mailing List
> For list archives: http://lists.mysql.com/win32
> To unsubscribe:    http://lists.mysql.com/[email protected]
>
>
> --
> MySQL Windows Mailing List
> For list archives: http://lists.mysql.com/win32
> To unsubscribe:
> http://lists.mysql.com/[email protected]
>
>



--
MySQL Windows Mailing List
For list archives: http://lists.mysql.com/win32
To unsubscribe:    http://lists.mysql.com/[email protected]


-- 
MySQL Windows Mailing List
For list archives: http://lists.mysql.com/win32
To unsubscribe:    http://lists.mysql.com/[email protected]


-- 
MySQL Windows Mailing List
For list archives: http://lists.mysql.com/win32
To unsubscribe:    http://lists.mysql.com/[email protected]