MySQL Error on Apache on WinXP Pro

------=_NextPart_000_0000_01C600D3.33A10D50
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: 8bit

I am getting a lot of this error but do not know what is causing it. My
installation of MySQL is on my E: drive. Is there a config file somewhere
that has this in it as the default?


File 'c:\mysql\share\charsets\?.conf' not found (Errcode: 2)
Character set '#33' is not a compiled character set and is not specified in
the 'c:\mysql\share\charsets\Index' file
File 'c:\mysql\share\charsets\?.conf' not found (Errcode: 2)
Character set '#33' is not a compiled character set and is not specified in
the 'c:\mysql\share\charsets\Index' file
File 'c:\mysql\share\charsets\?.conf' not found (Errcode: 2)
Character set '#33' is not a compiled character set and is not specified in
the 'c:\mysql\share\charsets\Index' file
File 'c:\mysql\share\charsets\?.conf' not found (Errcode: 2)
Character set '#33' is not a compiled character set and is not specified in
the 'c:\mysql\share\charsets\Index' file
File 'c:\mysql\share\charsets\?.conf' not found (Errcode: 2)
Character set '#33' is not a compiled character set and is not specified in
the 'c:\mysql\share\charsets\Index' file
File 'c:\mysql\share\charsets\?.conf' not found (Errcode: 2)
Character set '#33' is not a compiled character set and is not specified in
the 'c:\mysql\share\charsets\Index' file




------=_NextPart_000_0000_01C600D3.33A10D50
Content-Type: text/plain; charset=us-ascii


--
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
------=_NextPart_000_0000_01C600D3.33A10D50--

RE: MySQL Error on Apache on WinXP Pro

------=_NextPart_000_0012_01C60222.18E45A80
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: 8bit

I tried a few of the "solutions" found on the MySQL website when searching
for Error: 2. None of them seemed to work well and the ones that did
produced almost the same error. The text is the same but the error code is
now 22.

File 'c:\mysql\share\charsets\?.conf' not found (Errcode: 22)
Character set '#33' is not a compiled character set and is not specified in
the 'c:\mysql\share\charsets\Index' file

Searching the website there is no hits for Error: 22.

I do have the default set to utf8. When I removed that default, MySQL failed
to start. When I put it back in, it started. I do have tables with utf8 as
the default in them. Do I need to change every table? The purpose of that
was so I could use UniCode or any lang if I needed it.

Anyone have any ideas on what is next?

WinXP Pro
MySQL 4.1.15
Installation is on Drive E: (E:/MySQL)

Thanks.

Mike



> -----Original Message-----
> From: Michael Avila [mailto:Michael.Avila.1@sbcglobal.net]
> Sent: Wednesday, December 14, 2005 5:24 PM
> To: MySQL - Win32
> Subject: MySQL Error on Apache on WinXP Pro
>
> I am getting a lot of this error but do not know what is causing
> it. My installation of MySQL is on my E: drive. Is there a config
> file somewhere that has this in it as the default?
>
>
> File 'c:\mysql\share\charsets\?.conf' not found (Errcode: 2)
> Character set '#33' is not a compiled character set and is not
> specified in the 'c:\mysql\share\charsets\Index' file
> File 'c:\mysql\share\charsets\?.conf' not found (Errcode: 2)
> Character set '#33' is not a compiled character set and is not
> specified in the 'c:\mysql\share\charsets\Index' file
> File 'c:\mysql\share\charsets\?.conf' not found (Errcode: 2)
> Character set '#33' is not a compiled character set and is not
> specified in the 'c:\mysql\share\charsets\Index' file
> File 'c:\mysql\share\charsets\?.conf' not found (Errcode: 2)
> Character set '#33' is not a compiled character set and is not
> specified in the 'c:\mysql\share\charsets\Index' file
> File 'c:\mysql\share\charsets\?.conf' not found (Errcode: 2)
> Character set '#33' is not a compiled character set and is not
> specified in the 'c:\mysql\share\charsets\Index' file
> File 'c:\mysql\share\charsets\?.conf' not found (Errcode: 2)
> Character set '#33' is not a compiled character set and is not
> specified in the 'c:\mysql\share\charsets\Index' file
>
>


------=_NextPart_000_0012_01C60222.18E45A80
Content-Type: text/plain; charset=us-ascii


--
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
------=_NextPart_000_0012_01C60222.18E45A80--

Problem With Error 22

------=_NextPart_000_0010_01C60341.0EF4A730
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: 8bit

I am not getting a response from this message and I do not know if there is
no answer or if it is not getting through. Apologies if it is getting
through and you see this again.



I tried a few of the "solutions" found on the MySQL website when searching
for Error: 2. None of them seemed to work well and the ones that did
produced almost the same error. The text is the same but the error code is
now 22.

File 'c:\mysql\share\charsets\?.conf' not found (Errcode: 22)
Character set '#33' is not a compiled character set and is not specified in
the 'c:\mysql\share\charsets\Index' file

Searching the website there is no hits for Error: 22.

I do have the default set to utf8. When I removed that default, MySQL failed
to start. When I put it back in, it started. I do have tables with utf8 as
the default in them. Do I need to change every table? The purpose of that
was so I could use UniCode or any lang if I needed it.

Anyone have any ideas on what is next?

WinXP Pro
MySQL 4.1.15
Installation is on Drive E: (E:/MySQL)

Thanks.

Mike



> -----Original Message-----
> From: Michael Avila [mailto:Michael.Avila.1@sbcglobal.net]
> Sent: Wednesday, December 14, 2005 5:24 PM
> To: MySQL - Win32
> Subject: MySQL Error on Apache on WinXP Pro
>
> I am getting a lot of this error but do not know what is causing
> it. My installation of MySQL is on my E: drive. Is there a config
> file somewhere that has this in it as the default?
>
>
> File 'c:\mysql\share\charsets\?.conf' not found (Errcode: 2)
> Character set '#33' is not a compiled character set and is not
> specified in the 'c:\mysql\share\charsets\Index' file
> File 'c:\mysql\share\charsets\?.conf' not found (Errcode: 2)
> Character set '#33' is not a compiled character set and is not
> specified in the 'c:\mysql\share\charsets\Index' file
> File 'c:\mysql\share\charsets\?.conf' not found (Errcode: 2)
> Character set '#33' is not a compiled character set and is not
> specified in the 'c:\mysql\share\charsets\Index' file
> File 'c:\mysql\share\charsets\?.conf' not found (Errcode: 2)
> Character set '#33' is not a compiled character set and is not
> specified in the 'c:\mysql\share\charsets\Index' file
> File 'c:\mysql\share\charsets\?.conf' not found (Errcode: 2)
> Character set '#33' is not a compiled character set and is not
> specified in the 'c:\mysql\share\charsets\Index' file
> File 'c:\mysql\share\charsets\?.conf' not found (Errcode: 2)
> Character set '#33' is not a compiled character set and is not
> specified in the 'c:\mysql\share\charsets\Index' file
>
>


------=_NextPart_000_0010_01C60341.0EF4A730
Content-Type: text/plain; charset=us-ascii


--
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
------=_NextPart_000_0010_01C60341.0EF4A730--

Re: Problem With Error 22

--=_alternative 0005763C852570DB_=
Content-Type: text/plain; charset="ISO-8859-1"
Content-Transfer-Encoding: quoted-printable

"Michael Avila" wrote on 12/17/2005=20
07:35:38 PM:

> I am not getting a response from this message and I do not know if there =

is
> no answer or if it is not getting through. Apologies if it is getting
> through and you see this again.
>=20
>=20
>=20
> I tried a few of the "solutions" found on the MySQL website when=20
searching
> for Error: 2. None of them seemed to work well and the ones that did
> produced almost the same error. The text is the same but the error code=20
is
> now 22.
>=20
> =07File 'c:\mysql\share\charsets\?.conf' not found (Errcode: 22)
> =07Character set '#33' is not a compiled character set and is not=20
specified in
> the 'c:\mysql\share\charsets\Index' file
>=20
> Searching the website there is no hits for Error: 22.
>=20
> I do have the default set to utf8. When I removed that default, MySQL=20
failed
> to start. When I put it back in, it started. I do have tables with utf8=20
as
> the default in them. Do I need to change every table? The purpose of=20
that
> was so I could use UniCode or any lang if I needed it.=20
>=20
> Anyone have any ideas on what is next?=20
>=20
> WinXP Pro
> MySQL 4.1.15
> Installation is on Drive E: (E:/MySQL)
>=20
> Thanks.
>=20
> Mike
>=20
>=20
>=20
> > -----Original Message-----
> > From: Michael Avila [mailto:Michael.Avila.1@sbcglobal.net]=20
> > Sent: Wednesday, December 14, 2005 5:24 PM
> > To: MySQL - Win32
> > Subject: MySQL Error on Apache on WinXP Pro
> >=20
> > I am getting a lot of this error but do not know what is causing=20
> > it. My installation of MySQL is on my E: drive. Is there a config=20
> > file somewhere that has this in it as the default?
> >=20
> >=20
> > =07File 'c:\mysql\share\charsets\?.conf' not found (Errcode: 2)
> > =07Character set '#33' is not a compiled character set and is not=20
> > specified in the 'c:\mysql\share\charsets\Index' file
> > =07File 'c:\mysql\share\charsets\?.conf' not found (Errcode: 2)
> > =07Character set '#33' is not a compiled character set and is not=20
> > specified in the 'c:\mysql\share\charsets\Index' file
> > =07File 'c:\mysql\share\charsets\?.conf' not found (Errcode: 2)
> > =07Character set '#33' is not a compiled character set and is not=20
> > specified in the 'c:\mysql\share\charsets\Index' file
> > =07File 'c:\mysql\share\charsets\?.conf' not found (Errcode: 2)
> > =07Character set '#33' is not a compiled character set and is not=20
> > specified in the 'c:\mysql\share\charsets\Index' file
> > =07File 'c:\mysql\share\charsets\?.conf' not found (Errcode: 2)
> > =07Character set '#33' is not a compiled character set and is not=20
> > specified in the 'c:\mysql\share\charsets\Index' file
> > =07File 'c:\mysql\share\charsets\?.conf' not found (Errcode: 2)
> > =07Character set '#33' is not a compiled character set and is not=20
> > specified in the 'c:\mysql\share\charsets\Index' file
> >=20
> >=20
>=20


According to perror (a utility that comes with your MySQL installation)

C:\>cd mysql\bin

C:\mysql\bin>perror 22
OS error code 22: Invalid argument

C:\mysql\bin>perror 2
OS error code 2: No such file or directory

Please provide the following information about your setup:

a) the installation location of mysqld.exe (or whichever is appropriate to =

the version you are running)
b) the exact command you are using to launch mysqld.exe=20
c) the full path of your my.ini file
d) the following lines from your my.ini file:
i) basedir
ii) datadir

For more information:=20
http://dev.mysql.com/doc/refman/4.1/en/windows-create-option -file.html
http://dev.mysql.com/doc/refman/4.1/en/server-options.html

Shawn Green
Database Administrator
Unimin Corporation - Spruce Pine


--=_alternative 0005763C852570DB_=--

RE: Problem With Error 22

------=_NextPart_000_001A_01C6034F.1A5D2710
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: 8bit

a) E:\MySQL

b) It is started as a service:
"E:\MySQL\bin\mysqld-nt" --defaults-file="E:\MySQL\my.ini" MySQL
This command was created by MySQL the installation process

c) See b) above

d)
i) basedir basedir="E:/MySQL/"
ii) datadir
datadir="E:/MySQL/Data/"

Additional information:

character-sets-dir=E:\MySQL\\share\charsets
default-character-set=utf8


I tried to get rid of Error: 2 which is an invalid cahrset. Well, i got rid
of it and got Error: 22 instead!

Mike


-----Original Message-----
From: SGreen@unimin.com [mailto:SGreen@unimin.com]
Sent: Saturday, December 17, 2005 8:05 PM
To: Michael Avila
Cc: MySQL - Win32
Subject: Re: Problem With Error 22




"Michael Avila" wrote on 12/17/2005
07:35:38 PM:

> I am not getting a response from this message and I do not know if there
is
> no answer or if it is not getting through. Apologies if it is getting
> through and you see this again.
>
>
>
> I tried a few of the "solutions" found on the MySQL website when
searching
> for Error: 2. None of them seemed to work well and the ones that did
> produced almost the same error. The text is the same but the error code
is
> now 22.
>
> File 'c:\mysql\share\charsets\?.conf' not found (Errcode: 22)
> Character set '#33' is not a compiled character set and is not
specified in
> the 'c:\mysql\share\charsets\Index' file
>
> Searching the website there is no hits for Error: 22.
>
> I do have the default set to utf8. When I removed that default, MySQL
failed
> to start. When I put it back in, it started. I do have tables with utf8
as
> the default in them. Do I need to change every table? The purpose of
that
> was so I could use UniCode or any lang if I needed it.
>
> Anyone have any ideas on what is next?
>
> WinXP Pro
> MySQL 4.1.15
> Installation is on Drive E: (E:/MySQL)
>
> Thanks.
>
> Mike
>
>
>
> > -----Original Message-----
> > From: Michael Avila [mailto:Michael.Avila.1@sbcglobal.net]
> > Sent: Wednesday, December 14, 2005 5:24 PM
> > To: MySQL - Win32
> > Subject: MySQL Error on Apache on WinXP Pro
> >
> > I am getting a lot of this error but do not know what is causing
> > it. My installation of MySQL is on my E: drive. Is there a config
> > file somewhere that has this in it as the default?
> >
> >
> > File 'c:\mysql\share\charsets\?.conf' not found (Errcode: 2)
> > Character set '#33' is not a compiled character set and is not
> > specified in the 'c:\mysql\share\charsets\Index' file
> > File 'c:\mysql\share\charsets\?.conf' not found (Errcode: 2)
> > Character set '#33' is not a compiled character set and is not
> > specified in the 'c:\mysql\share\charsets\Index' file
> > File 'c:\mysql\share\charsets\?.conf' not found (Errcode: 2)
> > Character set '#33' is not a compiled character set and is not
> > specified in the 'c:\mysql\share\charsets\Index' file
> > File 'c:\mysql\share\charsets\?.conf' not found (Errcode: 2)
> > Character set '#33' is not a compiled character set and is not
> > specified in the 'c:\mysql\share\charsets\Index' file
> > File 'c:\mysql\share\charsets\?.conf' not found (Errcode: 2)
> > Character set '#33' is not a compiled character set and is not
> > specified in the 'c:\mysql\share\charsets\Index' file
> > File 'c:\mysql\share\charsets\?.conf' not found (Errcode: 2)
> > Character set '#33' is not a compiled character set and is not
> > specified in the 'c:\mysql\share\charsets\Index' file
> >
> >
>


According to perror (a utility that comes with your MySQL installation)

C:\>cd mysql\bin

C:\mysql\bin>perror 22
OS error code 22: Invalid argument

C:\mysql\bin>perror 2
OS error code 2: No such file or directory

Please provide the following information about your setup:

a) the installation location of mysqld.exe (or whichever is appropriate to
the version you are running)
b) the exact command you are using to launch mysqld.exe
c) the full path of your my.ini file
d) the following lines from your my.ini file:
i) basedir
ii) datadir

For more information:
http://dev.mysql.com/doc/refman/4.1/en/windows-create-option -file.html
http://dev.mysql.com/doc/refman/4.1/en/server-options.html

Shawn Green
Database Administrator
Unimin Corporation - Spruce Pine


------=_NextPart_000_001A_01C6034F.1A5D2710--

RE: Problem With Error 22

No it is not. I was told it was needed because of the \s needing an escape
char.

> -----Original Message-----
> From: Erich Dollansky [mailto:oceanare@pacific.net.sg]
> Sent: Saturday, December 17, 2005 9:58 PM
> To: Michael Avila
> Subject: Re: Problem With Error 22
>
>
> Hi,
>
> Michael Avila wrote:
> >
> > character-sets-dir=E:\MySQL\\share\charsets
>
> is this above just a typing error?
>
> > default-character-set=utf8
> >
> >
> > I tried to get rid of Error: 2 which is an invalid cahrset.
> Well, i got rid
> > of it and got Error: 22 instead!
>
> This is life.
>
> Erich


--
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

Re: Problem With Error 22

Him

Michael Avila wrote:
> No it is not. I was told it was needed because of the \s needing an escape
> char.

I also get always confused by the different characters needed to be
escaped in the different packages.

Have you tried this?

character-sets-dir=E:\MySQL\share\charsets

and

character-sets-dir=E:\\MySQL\\share\\charsets

'\' itself needs to be escaped very often but I never have heard of the 's'.

Erich
>
>
>>-----Original Message-----
>>From: Erich Dollansky [mailto:oceanare@pacific.net.sg]
>>Sent: Saturday, December 17, 2005 9:58 PM
>>To: Michael Avila
>>Subject: Re: Problem With Error 22
>>
>>
>>Hi,
>>
>>Michael Avila wrote:
>>
>>>character-sets-dir=E:\MySQL\\share\charsets
>>
>>is this above just a typing error?
>>
>>
>>>default-character-set=utf8
>>>
>>>
>>>I tried to get rid of Error: 2 which is an invalid cahrset.
>>
>>Well, i got rid
>>
>>>of it and got Error: 22 instead!
>>
>>This is life.
>>
>>Erich
>
>
>

--
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

RE: Problem With Error 22

I tried both. No difference. I read somewhere that \s is a space.

> -----Original Message-----
> From: Erich Dollansky [mailto:oceanare@pacific.net.sg]
> Sent: Saturday, December 17, 2005 10:10 PM
> To: Michael Avila
> Cc: MySQL - Win32
> Subject: Re: Problem With Error 22
>
>
> Him
>
> Michael Avila wrote:
> > No it is not. I was told it was needed because of the \s
> needing an escape
> > char.
>
> I also get always confused by the different characters needed to be
> escaped in the different packages.
>
> Have you tried this?
>
> character-sets-dir=E:\MySQL\share\charsets
>
> and
>
> character-sets-dir=E:\\MySQL\\share\\charsets
>
> '\' itself needs to be escaped very often but I never have heard
> of the 's'.
>
> Erich
> >
> >
> >>-----Original Message-----
> >>From: Erich Dollansky [mailto:oceanare@pacific.net.sg]
> >>Sent: Saturday, December 17, 2005 9:58 PM
> >>To: Michael Avila
> >>Subject: Re: Problem With Error 22
> >>
> >>
> >>Hi,
> >>
> >>Michael Avila wrote:
> >>
> >>>character-sets-dir=E:\MySQL\\share\charsets
> >>
> >>is this above just a typing error?
> >>
> >>
> >>>default-character-set=utf8
> >>>
> >>>
> >>>I tried to get rid of Error: 2 which is an invalid cahrset.
> >>
> >>Well, i got rid
> >>
> >>>of it and got Error: 22 instead!
> >>
> >>This is life.
> >>
> >>Erich
> >
> >
> >

--
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

Re: Problem With Error 22

Hi,

Michael Avila wrote:
> I tried both. No difference. I read somewhere that \s is a space.

have you ckecked what is actually in your charset directory?

Here is what the handbook says:

[mysqld]
# set basedir to your installation path
basedir=E:/mysql
# set datadir to the location of your data directory
datadir=E:/mydata/data

Note that Windows pathnames are specified in option files using
(forward) slashes rather than backslashes. If you do use backslashes,
you must double them:

[mysqld]
# set basedir to your installation path
basedir=E:\\mysql
# set datadir to the location of your data directory
datadir=E:\\mydata\\data



Erich

--
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