all of a sudden can"t connect to server..

I've been using MySQL server (4.1) on my W2k machine for over a year
w/no problems, connect from Tomcat and from Java stand-alone classes..
but the other day installed XAMPP (for PHP development, comes w/Apache,
MySQL) and since then cannot connect at all.. I simply have no idea
what's happening here.. I uninstalled XAMPP altogether (so now am back
to only my 4.1 installation I've always had..)

when try to connect directly from DOS shell (mysql -u.. etc.) I get this
error:

ERROR 2003 (HY000): Can't connect to MySQL server on 'localhost' (10061)

when in DOS shell navigate to c:\....MySQL Server 4.1\bin and try to run
mysql.exe (this is how you restart server?) get exact same error..

am running out of options.. would truly appreciate some suggestions
here.. thank you very much..

Frances



--
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: all of a sudden can"t connect to server..

Is it running as a service? If so did you try to restart the service?

-----Original Message-----
From: news [mailto:news@sea.gmane.org]On Behalf Of Frances
Sent: Wednesday, June 07, 2006 11:14 AM
To: win32@lists.mysql.com
Subject: all of a sudden can't connect to server..



I've been using MySQL server (4.1) on my W2k machine for over a year=20
w/no problems, connect from Tomcat and from Java stand-alone classes..=20
but the other day installed XAMPP (for PHP development, comes w/Apache,=20
MySQL) and since then cannot connect at all.. I simply have no idea=20
what's happening here.. I uninstalled XAMPP altogether (so now am back=20
to only my 4.1 installation I've always had..)

when try to connect directly from DOS shell (mysql -u.. etc.) I get this =

error:

ERROR 2003 (HY000): Can't connect to MySQL server on 'localhost' =
(10061)

when in DOS shell navigate to c:\....MySQL Server 4.1\bin and try to run =

mysql.exe (this is how you restart server?) get exact same error..

am running out of options.. would truly appreciate some suggestions=20
here.. thank you very much..

Frances



--=20
MySQL Windows Mailing List
For list archives: http://lists.mysql.com/win32
To unsubscribe: =
http://lists.mysql.com/win32?unsub=3Dkjanuski@phillynews.com


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

RE: all of a sudden can"t connect to server..

Mysql.exe is not how you restart the server. That is the client.
You need to be looking for mysqld.exe.
Better yet, if your mysql is configured to run as a service, try starting=
it using 'services' in Administrative tools. If you can't find that, try=
"net start mysql" from a command prompt.

More to the point, however, you need to find out what went wrong. I suspe=
ct that installing XAMPP (which apparently indtalls a new instance of mys=
ql) has over-written or otherwise obliterated your original mysql. I sure=
hope you backed up your data first.
You might want to check that your original mysql is still installed, and t=
hat XAMPP hasn't damaged it.
=20


Regards,
Leigh
=20
Leigh Sharpe
Network Systems Engineer
Pacific Wireless
Ph 9584 8966
Mob 0408 009 502
email lsharpe@pacificwireless.com.au
web www.pacificwireless.com.au

-----Original Message-----
From: Frances [mailto:fdr58@yahoo.com]=20
Sent: Thursday, June 08, 2006 1:14 AM
To: win32@lists.mysql.com
Subject: all of a sudden can't connect to server..


I've been using MySQL server (4.1) on my W2k machine for over a year w/no=
problems, connect from Tomcat and from Java stand-alone classes..=20
but the other day installed XAMPP (for PHP development, comes w/Apache,
MySQL) and since then cannot connect at all.. I simply have no idea what=
's happening here.. I uninstalled XAMPP altogether (so now am back to onl=
y my 4.1 installation I've always had..)

when try to connect directly from DOS shell (mysql -u.. etc.) I get this
error:

ERROR 2003 (HY000): Can't connect to MySQL server on 'localhost' (1006=
1)

when in DOS shell navigate to c:\....MySQL Server 4.1\bin and try to run m=
ysql.exe (this is how you restart server?) get exact same error..

am running out of options.. would truly appreciate some suggestions here.=
thank you very much..

Frances



--
MySQL Windows Mailing List
For list archives: http://lists.mysql.com/win32
To unsubscribe: http://lists.mysql.com/win32?unsub=3Dlsharpe@pacificwi=
reless.com.au



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

Re: all of a sudden can"t connect to server..

Leigh Sharpe wrote:
> Mysql.exe is not how you restart the server. That is the client.
> You need to be looking for mysqld.exe.
> Better yet, if your mysql is configured to run as a service, try starting it using
> 'services' in Administrative tools. If you can't find that, try "net start mysql"
> from a command prompt.
>
> More to the point, however, you need to find out what went wrong. I suspect that installing XAMPP
> (which apparently indtalls a new instance of mysql) has over-written or otherwise obliterated your
> original mysql. I sure hope you backed up your data first.
> You might want to check that your original mysql is still installed, and that XAMPP hasn't damaged it.

Thank you for your response.. this is the situation: my orig MySQL
installation, at at C:\Program Files\MySQL\MySQL Server 4.1.. is still
all there (including data, bin, Docs, share dirs.. I copied data to
somewhere else in my HD just in case, but it's still all where it always
was..) in bin dir all executables are there.. in bin dir I run what you
said, namely 'net start mysql' (I assume I need to run this from bin
dir) and get this error:

The service name is invalid.
More help is available by typing NET HELPMSG 2185.

when type net helpmsg 2185 (tried upper and lower case) get error "the
service name is invalid"

I REALLY need to re-install XAMPP, I really need it for PHP (I
uninstalled it in the hope that it would fix this problem, but it
hasn't..)
I just ran 'mysqld.exe' and got no error, got taken back to prompt (do I
need to type 'exe' here or not, at any rate tried both..) but still
can't connect to either console client or from a java class.. I also
tried safe_mysqld &, which I saw on line, also doesn't work.. oh
brother.. what on earth is going on here.. (tried changing port to
3307, but I can't, there's no 'ok' or 'apply' button in
MySQLInstanceConfig.exe, if I just close dialog after I change port it
doesn't take, next time go to it it's back to 3306... ok, again many
thanks for your help..








>
>
>
> Regards,
> Leigh
>
> Leigh Sharpe
> Network Systems Engineer
> Pacific Wireless
> Ph 9584 8966
> Mob 0408 009 502
> email lsharpe@pacificwireless.com.au
> web www.pacificwireless.com.au
>
> -----Original Message-----
> From: Frances [mailto:fdr58@yahoo.com]
> Sent: Thursday, June 08, 2006 1:14 AM
> To: win32@lists.mysql.com
> Subject: all of a sudden can't connect to server..
>
>
> I've been using MySQL server (4.1) on my W2k machine for over a year w/no problems, connect from Tomcat and from Java stand-alone classes..
> but the other day installed XAMPP (for PHP development, comes w/Apache,
> MySQL) and since then cannot connect at all.. I simply have no idea what's happening here.. I uninstalled XAMPP altogether (so now am back to only my 4.1 installation I've always had..)
>
> when try to connect directly from DOS shell (mysql -u.. etc.) I get this
> error:
>
> ERROR 2003 (HY000): Can't connect to MySQL server on 'localhost' (10061)
>
> when in DOS shell navigate to c:\....MySQL Server 4.1\bin and try to run mysql.exe (this is how you restart server?) get exact same error..
>
> am running out of options.. would truly appreciate some suggestions here.. thank you very much..
>
> Frances
>
>
>
> --
> MySQL Windows Mailing List
> For list archives: http://lists.mysql.com/win32
> To unsubscribe: http://lists.mysql.com/win32?unsub=lsharpe@pacificwireless.c om.au
>
>
>


--
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: all of a sudden can"t connect to server..

Have you checked the services panel in admin tools? Is there a service
called mysql? If not you need to install a service
"http://dev.mysql.com/doc/refman/5.0/en/windows-start-servic e.html".

When you look at the properties of the of an existing service where is
the Path to executable pointing? Is it pointing at the bin of your mysql
installation? If not you need either to delete the service and reinstall
or change the path to executable. Check your regkey:
HKEY_LOCAL_MACHINE.SYSTEM.CurrentControlSet.Services.MySQL

Can you start an existing service that is pointing at your valid
MySQL/bin directory? If not, check the event viewer.

If the database isn't running you won't be able to call mysql from
command line or connect from a java class.

Tobin

Frances wrote:
> Leigh Sharpe wrote:
>> Mysql.exe is not how you restart the server. That is the client.
>> You need to be looking for mysqld.exe.
>> Better yet, if your mysql is configured to run as a service, try
>> starting it using 'services' in Administrative tools. If you can't
>> find that, try "net start mysql"
> > from a command prompt.
>>
>> More to the point, however, you need to find out what went wrong. I
>> suspect that installing XAMPP (which apparently indtalls a new
>> instance of mysql) has over-written or otherwise obliterated your
> > original mysql. I sure hope you backed up your data first.
>> You might want to check that your original mysql is still installed,
>> and that XAMPP hasn't damaged it.
>
> Thank you for your response.. this is the situation: my orig MySQL
> installation, at at C:\Program Files\MySQL\MySQL Server 4.1.. is still
> all there (including data, bin, Docs, share dirs.. I copied data to
> somewhere else in my HD just in case, but it's still all where it
> always was..) in bin dir all executables are there.. in bin dir I run
> what you said, namely 'net start mysql' (I assume I need to run this
> from bin dir) and get this error:
>
> The service name is invalid.
> More help is available by typing NET HELPMSG 2185.
>
> when type net helpmsg 2185 (tried upper and lower case) get error "the
> service name is invalid"
>
> I REALLY need to re-install XAMPP, I really need it for PHP (I
> uninstalled it in the hope that it would fix this problem, but it
> hasn't..)
> I just ran 'mysqld.exe' and got no error, got taken back to prompt (do
> I need to type 'exe' here or not, at any rate tried both..) but still
> can't connect to either console client or from a java class.. I also
> tried safe_mysqld &, which I saw on line, also doesn't work.. oh
> brother.. what on earth is going on here.. (tried changing port to
> 3307, but I can't, there's no 'ok' or 'apply' button in
> MySQLInstanceConfig.exe, if I just close dialog after I change port it
> doesn't take, next time go to it it's back to 3306... ok, again many
> thanks for your help..
>
>
>
>
>
>
>
>
>>
>>
>>
>> Regards,
>> Leigh
>>
>> Leigh Sharpe
>> Network Systems Engineer
>> Pacific Wireless
>> Ph 9584 8966
>> Mob 0408 009 502
>> email lsharpe@pacificwireless.com.au
>> web www.pacificwireless.com.au
>>
>> -----Original Message-----
>> From: Frances [mailto:fdr58@yahoo.com] Sent: Thursday, June 08, 2006
>> 1:14 AM
>> To: win32@lists.mysql.com
>> Subject: all of a sudden can't connect to server..
>>
>>
>> I've been using MySQL server (4.1) on my W2k machine for over a year
>> w/no problems, connect from Tomcat and from Java stand-alone
>> classes.. but the other day installed XAMPP (for PHP development,
>> comes w/Apache,
>> MySQL) and since then cannot connect at all.. I simply have no idea
>> what's happening here.. I uninstalled XAMPP altogether (so now am
>> back to only my 4.1 installation I've always had..)
>>
>> when try to connect directly from DOS shell (mysql -u.. etc.) I get this
>> error:
>>
>> ERROR 2003 (HY000): Can't connect to MySQL server on 'localhost'
>> (10061)
>>
>> when in DOS shell navigate to c:\....MySQL Server 4.1\bin and try to
>> run mysql.exe (this is how you restart server?) get exact same error..
>>
>> am running out of options.. would truly appreciate some suggestions
>> here.. thank you very much..
>>
>> Frances
>>
>>
>>
>> --
>> MySQL Windows Mailing List
>> For list archives: http://lists.mysql.com/win32
>> To unsubscribe:
>> http://lists.mysql.com/win32?unsub=lsharpe@pacificwireless.c om.au
>>
>>
>>
>
>


--
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: all of a sudden can"t connect to server..

Tobin, thank you very much for your response.. last night finally
managed to run this successfully: mysqld-nt --install
(which I got from here, http://coronet.iicm.edu/mysql/start.html)

then, when went to services, saw MySQL there, but when went to start it
got following error:

could not start the MySQL service on Local Computer.
Error 1067: the process terminated unexpectedly.

(tried again today, after rebooting machine, same thing..)

to answer your question re path to executable:

"C:\Program Files\MySQL\MySQL Server 4.1\bin\mysqld-nt" MySQL

(yes it's pointing to bin of my installation, in other words..)

(check regkey? would need more info here, have never done anything to
registry, regkeys.. but well, hopefully won't come to that, since path
does seem to point to right location..) again many thanks for yr help..
I really need to fix this.. can't understand what's gone wrong here all
of a sudden after having used MySQL server on my machine for over a year
now...



Tobin Cataldo wrote:
> Have you checked the services panel in admin tools? Is there a service
> called mysql? If not you need to install a service
> "http://dev.mysql.com/doc/refman/5.0/en/windows-start-servic e.html".
>
> When you look at the properties of the of an existing service where is
> the Path to executable pointing? Is it pointing at the bin of your mysql
> installation? If not you need either to delete the service and reinstall
> or change the path to executable. Check your regkey:
> HKEY_LOCAL_MACHINE.SYSTEM.CurrentControlSet.Services.MySQL
>
> Can you start an existing service that is pointing at your valid
> MySQL/bin directory? If not, check the event viewer.
>
> If the database isn't running you won't be able to call mysql from
> command line or connect from a java class.
>
> Tobin
>
> Frances wrote:
>
>> Leigh Sharpe wrote:
>>
>>> Mysql.exe is not how you restart the server. That is the client.
>>> You need to be looking for mysqld.exe.
>>> Better yet, if your mysql is configured to run as a service, try
>>> starting it using 'services' in Administrative tools. If you can't
>>> find that, try "net start mysql"
>>
>> > from a command prompt.
>>
>>>
>>> More to the point, however, you need to find out what went wrong. I
>>> suspect that installing XAMPP (which apparently indtalls a new
>>> instance of mysql) has over-written or otherwise obliterated your
>>
>> > original mysql. I sure hope you backed up your data first.
>>
>>> You might want to check that your original mysql is still installed,
>>> and that XAMPP hasn't damaged it.
>>
>>
>> Thank you for your response.. this is the situation: my orig MySQL
>> installation, at at C:\Program Files\MySQL\MySQL Server 4.1.. is still
>> all there (including data, bin, Docs, share dirs.. I copied data to
>> somewhere else in my HD just in case, but it's still all where it
>> always was..) in bin dir all executables are there.. in bin dir I run
>> what you said, namely 'net start mysql' (I assume I need to run this
>> from bin dir) and get this error:
>>
>> The service name is invalid.
>> More help is available by typing NET HELPMSG 2185.
>>
>> when type net helpmsg 2185 (tried upper and lower case) get error "the
>> service name is invalid"
>>
>> I REALLY need to re-install XAMPP, I really need it for PHP (I
>> uninstalled it in the hope that it would fix this problem, but it
>> hasn't..)
>> I just ran 'mysqld.exe' and got no error, got taken back to prompt (do
>> I need to type 'exe' here or not, at any rate tried both..) but still
>> can't connect to either console client or from a java class.. I also
>> tried safe_mysqld &, which I saw on line, also doesn't work.. oh
>> brother.. what on earth is going on here.. (tried changing port to
>> 3307, but I can't, there's no 'ok' or 'apply' button in
>> MySQLInstanceConfig.exe, if I just close dialog after I change port it
>> doesn't take, next time go to it it's back to 3306... ok, again many
>> thanks for your help..
>>
>>
>>
>>
>>
>>
>>
>>
>>>
>>>
>>>
>>> Regards,
>>> Leigh
>>>
>>> Leigh Sharpe
>>> Network Systems Engineer
>>> Pacific Wireless
>>> Ph 9584 8966
>>> Mob 0408 009 502
>>> email lsharpe@pacificwireless.com.au
>>> web www.pacificwireless.com.au
>>>
>>> -----Original Message-----
>>> From: Frances [mailto:fdr58@yahoo.com] Sent: Thursday, June 08, 2006
>>> 1:14 AM
>>> To: win32@lists.mysql.com
>>> Subject: all of a sudden can't connect to server..
>>>
>>>
>>> I've been using MySQL server (4.1) on my W2k machine for over a year
>>> w/no problems, connect from Tomcat and from Java stand-alone
>>> classes.. but the other day installed XAMPP (for PHP development,
>>> comes w/Apache,
>>> MySQL) and since then cannot connect at all.. I simply have no idea
>>> what's happening here.. I uninstalled XAMPP altogether (so now am
>>> back to only my 4.1 installation I've always had..)
>>>
>>> when try to connect directly from DOS shell (mysql -u.. etc.) I get this
>>> error:
>>>
>>> ERROR 2003 (HY000): Can't connect to MySQL server on 'localhost'
>>> (10061)
>>>
>>> when in DOS shell navigate to c:\....MySQL Server 4.1\bin and try to
>>> run mysql.exe (this is how you restart server?) get exact same error..
>>>
>>> am running out of options.. would truly appreciate some suggestions
>>> here.. thank you very much..
>>>
>>> Frances
>>>
>>>
>>>
>>> --
>>> MySQL Windows Mailing List
>>> For list archives: http://lists.mysql.com/win32
>>> To unsubscribe:
>>> http://lists.mysql.com/win32?unsub=lsharpe@pacificwireless.c om.au
>>>
>>>
>>>
>>
>>
>
>


--
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: all of a sudden can"t connect to server..

And what does the event viewer say?

Frances wrote:
>
> Tobin, thank you very much for your response.. last night finally
> managed to run this successfully: mysqld-nt --install
> (which I got from here, http://coronet.iicm.edu/mysql/start.html)
>
> then, when went to services, saw MySQL there, but when went to start
> it got following error:
>
> could not start the MySQL service on Local Computer.
> Error 1067: the process terminated unexpectedly.
>
> (tried again today, after rebooting machine, same thing..)
>
> to answer your question re path to executable:
>
> "C:\Program Files\MySQL\MySQL Server 4.1\bin\mysqld-nt" MySQL
>
> (yes it's pointing to bin of my installation, in other words..)
>
> (check regkey? would need more info here, have never done anything to
> registry, regkeys.. but well, hopefully won't come to that, since
> path does seem to point to right location..) again many thanks for yr
> help.. I really need to fix this.. can't understand what's gone wrong
> here all of a sudden after having used MySQL server on my machine for
> over a year now...
>
>
>
> Tobin Cataldo wrote:
>> Have you checked the services panel in admin tools? Is there a
>> service called mysql? If not you need to install a service
>> "http://dev.mysql.com/doc/refman/5.0/en/windows-start-servic e.html".
>>
>> When you look at the properties of the of an existing service where
>> is the Path to executable pointing? Is it pointing at the bin of your
>> mysql installation? If not you need either to delete the service and
>> reinstall or change the path to executable. Check your regkey:
>> HKEY_LOCAL_MACHINE.SYSTEM.CurrentControlSet.Services.MySQL
>>
>> Can you start an existing service that is pointing at your valid
>> MySQL/bin directory? If not, check the event viewer.
>>
>> If the database isn't running you won't be able to call mysql from
>> command line or connect from a java class.
>>
>> Tobin
>>
>> Frances wrote:
>>
>>> Leigh Sharpe wrote:
>>>
>>>> Mysql.exe is not how you restart the server. That is the client.
>>>> You need to be looking for mysqld.exe.
>>>> Better yet, if your mysql is configured to run as a service, try
>>>> starting it using 'services' in Administrative tools. If you can't
>>>> find that, try "net start mysql"
>>>
>>> > from a command prompt.
>>>
>>>>
>>>> More to the point, however, you need to find out what went wrong. I
>>>> suspect that installing XAMPP (which apparently indtalls a new
>>>> instance of mysql) has over-written or otherwise obliterated your
>>>
>>> > original mysql. I sure hope you backed up your data first.
>>>
>>>> You might want to check that your original mysql is still
>>>> installed, and that XAMPP hasn't damaged it.
>>>
>>>
>>> Thank you for your response.. this is the situation: my orig MySQL
>>> installation, at at C:\Program Files\MySQL\MySQL Server 4.1.. is
>>> still all there (including data, bin, Docs, share dirs.. I copied
>>> data to somewhere else in my HD just in case, but it's still all
>>> where it always was..) in bin dir all executables are there.. in
>>> bin dir I run what you said, namely 'net start mysql' (I assume I
>>> need to run this from bin dir) and get this error:
>>>
>>> The service name is invalid.
>>> More help is available by typing NET HELPMSG 2185.
>>>
>>> when type net helpmsg 2185 (tried upper and lower case) get error
>>> "the service name is invalid"
>>>
>>> I REALLY need to re-install XAMPP, I really need it for PHP (I
>>> uninstalled it in the hope that it would fix this problem, but it
>>> hasn't..)
>>> I just ran 'mysqld.exe' and got no error, got taken back to prompt
>>> (do I need to type 'exe' here or not, at any rate tried both..) but
>>> still can't connect to either console client or from a java class..
>>> I also tried safe_mysqld &, which I saw on line, also doesn't
>>> work.. oh brother.. what on earth is going on here.. (tried
>>> changing port to 3307, but I can't, there's no 'ok' or 'apply'
>>> button in MySQLInstanceConfig.exe, if I just close dialog after I
>>> change port it doesn't take, next time go to it it's back to
>>> 3306... ok, again many thanks for your help..
>>>
>>>
>>>
>>>
>>>
>>>
>>>
>>>
>>>>
>>>>
>>>>
>>>> Regards,
>>>> Leigh
>>>>
>>>> Leigh Sharpe
>>>> Network Systems Engineer
>>>> Pacific Wireless
>>>> Ph 9584 8966
>>>> Mob 0408 009 502
>>>> email lsharpe@pacificwireless.com.au
>>>> web www.pacificwireless.com.au
>>>>
>>>> -----Original Message-----
>>>> From: Frances [mailto:fdr58@yahoo.com] Sent: Thursday, June 08,
>>>> 2006 1:14 AM
>>>> To: win32@lists.mysql.com
>>>> Subject: all of a sudden can't connect to server..
>>>>
>>>>
>>>> I've been using MySQL server (4.1) on my W2k machine for over a
>>>> year w/no problems, connect from Tomcat and from Java stand-alone
>>>> classes.. but the other day installed XAMPP (for PHP development,
>>>> comes w/Apache,
>>>> MySQL) and since then cannot connect at all.. I simply have no
>>>> idea what's happening here.. I uninstalled XAMPP altogether (so now
>>>> am back to only my 4.1 installation I've always had..)
>>>>
>>>> when try to connect directly from DOS shell (mysql -u.. etc.) I get
>>>> this
>>>> error:
>>>>
>>>> ERROR 2003 (HY000): Can't connect to MySQL server on 'localhost'
>>>> (10061)
>>>>
>>>> when in DOS shell navigate to c:\....MySQL Server 4.1\bin and try
>>>> to run mysql.exe (this is how you restart server?) get exact same
>>>> error..
>>>>
>>>> am running out of options.. would truly appreciate some suggestions
>>>> here.. thank you very much..
>>>>
>>>> Frances
>>>>
>>>>
>>>>
>>>> --
>>>> MySQL Windows Mailing List
>>>> For list archives: http://lists.mysql.com/win32
>>>> To unsubscribe:
>>>> http://lists.mysql.com/win32?unsub=lsharpe@pacificwireless.c om.au
>>>>
>>>>
>>>>
>>>
>>>
>>
>>
>
>


--
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: all of a sudden can"t connect to server..

what's event viewer? (searched google for error 1067, so opened .err
file, this is what is says (at the bottom, long file):

060607 22:37:33 [Note] mysqld: Shutdown complete

InnoDB: Error: log file .\ib_logfile0 is of different size 0 10485760 bytes
InnoDB: than specified in the .cnf file 0 5242880 bytes!
060607 22:47:57 [ERROR] Can't init databases
060607 22:47:57 [ERROR] Aborting

060607 22:47:57 [Note] mysqld.exe: Shutdown complete

(someone in a MySQL.com forum is also helping me, he suggested changing
this var in my.ini innodb_log_file_size to 20M, which I did, tried again
to restart, same error.. (maybe need to restart machine? you know,
this is all very weird, I never had MySQL server installed as a service
(I think), yet never had to turn it on, never had to do anything or
worry about it in any way, db's were always accessible to me with no
problems..)


Tobin Cataldo wrote:
> And what does the event viewer say?
>
> Frances wrote:
>
>>
>> Tobin, thank you very much for your response.. last night finally
>> managed to run this successfully: mysqld-nt --install
>> (which I got from here, http://coronet.iicm.edu/mysql/start.html)
>>
>> then, when went to services, saw MySQL there, but when went to start
>> it got following error:
>>
>> could not start the MySQL service on Local Computer.
>> Error 1067: the process terminated unexpectedly.
>>
>> (tried again today, after rebooting machine, same thing..)
>>
>> to answer your question re path to executable:
>>
>> "C:\Program Files\MySQL\MySQL Server 4.1\bin\mysqld-nt" MySQL
>>
>> (yes it's pointing to bin of my installation, in other words..)
>>
>> (check regkey? would need more info here, have never done anything to
>> registry, regkeys.. but well, hopefully won't come to that, since
>> path does seem to point to right location..) again many thanks for yr
>> help.. I really need to fix this.. can't understand what's gone wrong
>> here all of a sudden after having used MySQL server on my machine for
>> over a year now...
>>
>>
>>
>> Tobin Cataldo wrote:
>>
>>> Have you checked the services panel in admin tools? Is there a
>>> service called mysql? If not you need to install a service
>>> "http://dev.mysql.com/doc/refman/5.0/en/windows-start-servic e.html".
>>>
>>> When you look at the properties of the of an existing service where
>>> is the Path to executable pointing? Is it pointing at the bin of your
>>> mysql installation? If not you need either to delete the service and
>>> reinstall or change the path to executable. Check your regkey:
>>> HKEY_LOCAL_MACHINE.SYSTEM.CurrentControlSet.Services.MySQL
>>>
>>> Can you start an existing service that is pointing at your valid
>>> MySQL/bin directory? If not, check the event viewer.
>>>
>>> If the database isn't running you won't be able to call mysql from
>>> command line or connect from a java class.
>>>
>>> Tobin
>>>
>>> Frances wrote:
>>>
>>>> Leigh Sharpe wrote:
>>>>
>>>>> Mysql.exe is not how you restart the server. That is the client.
>>>>> You need to be looking for mysqld.exe.
>>>>> Better yet, if your mysql is configured to run as a service, try
>>>>> starting it using 'services' in Administrative tools. If you can't
>>>>> find that, try "net start mysql"
>>>>
>>>>
>>>> > from a command prompt.
>>>>
>>>>>
>>>>> More to the point, however, you need to find out what went wrong. I
>>>>> suspect that installing XAMPP (which apparently indtalls a new
>>>>> instance of mysql) has over-written or otherwise obliterated your
>>>>
>>>>
>>>> > original mysql. I sure hope you backed up your data first.
>>>>
>>>>> You might want to check that your original mysql is still
>>>>> installed, and that XAMPP hasn't damaged it.
>>>>
>>>>
>>>>
>>>> Thank you for your response.. this is the situation: my orig MySQL
>>>> installation, at at C:\Program Files\MySQL\MySQL Server 4.1.. is
>>>> still all there (including data, bin, Docs, share dirs.. I copied
>>>> data to somewhere else in my HD just in case, but it's still all
>>>> where it always was..) in bin dir all executables are there.. in
>>>> bin dir I run what you said, namely 'net start mysql' (I assume I
>>>> need to run this from bin dir) and get this error:
>>>>
>>>> The service name is invalid.
>>>> More help is available by typing NET HELPMSG 2185.
>>>>
>>>> when type net helpmsg 2185 (tried upper and lower case) get error
>>>> "the service name is invalid"
>>>>
>>>> I REALLY need to re-install XAMPP, I really need it for PHP (I
>>>> uninstalled it in the hope that it would fix this problem, but it
>>>> hasn't..)
>>>> I just ran 'mysqld.exe' and got no error, got taken back to prompt
>>>> (do I need to type 'exe' here or not, at any rate tried both..) but
>>>> still can't connect to either console client or from a java class..
>>>> I also tried safe_mysqld &, which I saw on line, also doesn't
>>>> work.. oh brother.. what on earth is going on here.. (tried
>>>> changing port to 3307, but I can't, there's no 'ok' or 'apply'
>>>> button in MySQLInstanceConfig.exe, if I just close dialog after I
>>>> change port it doesn't take, next time go to it it's back to
>>>> 3306... ok, again many thanks for your help..
>>>>
>>>>
>>>>
>>>>
>>>>
>>>>
>>>>
>>>>
>>>>>
>>>>>
>>>>>
>>>>> Regards,
>>>>> Leigh
>>>>>
>>>>> Leigh Sharpe
>>>>> Network Systems Engineer
>>>>> Pacific Wireless
>>>>> Ph 9584 8966
>>>>> Mob 0408 009 502
>>>>> email lsharpe@pacificwireless.com.au
>>>>> web www.pacificwireless.com.au
>>>>>
>>>>> -----Original Message-----
>>>>> From: Frances [mailto:fdr58@yahoo.com] Sent: Thursday, June 08,
>>>>> 2006 1:14 AM
>>>>> To: win32@lists.mysql.com
>>>>> Subject: all of a sudden can't connect to server..
>>>>>
>>>>>
>>>>> I've been using MySQL server (4.1) on my W2k machine for over a
>>>>> year w/no problems, connect from Tomcat and from Java stand-alone
>>>>> classes.. but the other day installed XAMPP (for PHP development,
>>>>> comes w/Apache,
>>>>> MySQL) and since then cannot connect at all.. I simply have no
>>>>> idea what's happening here.. I uninstalled XAMPP altogether (so now
>>>>> am back to only my 4.1 installation I've always had..)
>>>>>
>>>>> when try to connect directly from DOS shell (mysql -u.. etc.) I get
>>>>> this
>>>>> error:
>>>>>
>>>>> ERROR 2003 (HY000): Can't connect to MySQL server on 'localhost'
>>>>> (10061)
>>>>>
>>>>> when in DOS shell navigate to c:\....MySQL Server 4.1\bin and try
>>>>> to run mysql.exe (this is how you restart server?) get exact same
>>>>> error..
>>>>>
>>>>> am running out of options.. would truly appreciate some suggestions
>>>>> here.. thank you very much..
>>>>>
>>>>> Frances
>>>>>
>>>>>
>>>>>
>>>>> --
>>>>> MySQL Windows Mailing List
>>>>> For list archives: http://lists.mysql.com/win32
>>>>> To unsubscribe:
>>>>> http://lists.mysql.com/win32?unsub=lsharpe@pacificwireless.c om.au
>>>>>
>>>>>
>>>>>
>>>>
>>>>
>>>
>>>
>>
>>
>
>


--
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: all of a sudden can"t connect to server..

On 6/8/06, Frances wrote:
> what's event viewer? (searched google for error 1067, so opened .err
> file, this is what is says (at the bottom, long file):
>
> 060607 22:37:33 [Note] mysqld: Shutdown complete
>
> InnoDB: Error: log file .\ib_logfile0 is of different size 0 10485760 bytes
> InnoDB: than specified in the .cnf file 0 5242880 bytes!
> 060607 22:47:57 [ERROR] Can't init databases
> 060607 22:47:57 [ERROR] Aborting
>
> 060607 22:47:57 [Note] mysqld.exe: Shutdown complete
>
> (someone in a MySQL.com forum is also helping me, he suggested changing
> this var in my.ini innodb_log_file_size to 20M, which I did, tried again
> to restart, same error.. (maybe need to restart machine? you know,
> this is all very weird, I never had MySQL server installed as a service
> (I think), yet never had to turn it on, never had to do anything or
> worry about it in any way, db's were always accessible to me with no
> problems..)

First of all, understand how MySQL works, at init, it searches for
configs in files that can be in numerous location of your disk, mostly
they're named "my.cnf" or "my.ini", that if your service does not
point at it using "--defaults-file=" on your "Services" windows
at MySQL's service properties.

Check if you find this file, it was probably ovewritten after you
install/uninstall this other app you used, check if it has a
configuration named "datadir" and see if it points at your "data"
directory. It seems mysql was unable to locate its main database
"mysql".

Read the manual, the whole installation part, if you understand HOW
mysql works you'll be all set. You really need the basis for this to
work as we can't see or work with your system directly, only give you
advice.

--
Daniel da Veiga
Computer Operator - RS - Brazil
-----BEGIN GEEK CODE BLOCK-----
Version: 3.1
GCM/IT/P/O d-? s:- a? C++$ UBLA++ P+ L++ E--- W+++$ N o+ K- w O M- V-
PS PE Y PGP- t+ 5 X+++ R+* tv b+ DI+++ D+ G+ e h+ r+ y++
------END GEEK CODE BLOCK------

--
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: all of a sudden can"t connect to server..

Daniel da Veiga wrote:
> On 6/8/06, Frances wrote:
>
>> what's event viewer? (searched google for error 1067, so opened .err
>> file, this is what is says (at the bottom, long file):
>>
>> 060607 22:37:33 [Note] mysqld: Shutdown complete
>>
>> InnoDB: Error: log file .\ib_logfile0 is of different size 0 10485760
>> bytes
>> InnoDB: than specified in the .cnf file 0 5242880 bytes!
>> 060607 22:47:57 [ERROR] Can't init databases
>> 060607 22:47:57 [ERROR] Aborting
>>
>> 060607 22:47:57 [Note] mysqld.exe: Shutdown complete
>>
>> (someone in a MySQL.com forum is also helping me, he suggested changing
>> this var in my.ini innodb_log_file_size to 20M, which I did, tried again
>> to restart, same error.. (maybe need to restart machine? you know,
>> this is all very weird, I never had MySQL server installed as a service
>> (I think), yet never had to turn it on, never had to do anything or
>> worry about it in any way, db's were always accessible to me with no
>> problems..)
>
>
> First of all, understand how MySQL works, at init, it searches for
> configs in files that can be in numerous location of your disk, mostly
> they're named "my.cnf" or "my.ini", that if your service does not
> point at it using "--defaults-file=" on your "Services" windows
> at MySQL's service properties.
>
> Check if you find this file, it was probably ovewritten after you
> install/uninstall this other app you used, check if it has a
> configuration named "datadir" and see if it points at your "data"
> directory. It seems mysql was unable to locate its main database
> "mysql".
>
> Read the manual, the whole installation part, if you understand HOW
> mysql works you'll be all set. You really need the basis for this to
> work as we can't see or work with your system directly, only give you
> advice.

Daniel, thank you very much for your response.. this is what is says in
manual re .cnf/.ini files:

----
In MySQL installations prior to version 4.1.5 it was customary to name
the server configuration file 'my.cnf' or 'my.ini' and locate the file
either at 'c:\my.cnf' or 'c:\Windows\my.ini'.
The new MySQL Configuration Wizard places the 'my.ini' file in the
installation directory of the MySQL server. This helps associate
configuration files with particular server instances.
----

my.ini is there, but there's no .cnf file.. searched my entire C-drive
for a my.cnf file, it doesn't exist... (so don't understand why error
message mentions .cnf file..)

error I'm getting is can't find my databases, but my databases are all
there, where they have always been.. ok, where do I go from here
please... (would LOVE to know why no warning comes with XAMPP saying it
can damage existing MySQL installation.. I've never had any problems
whatsoever w/MySQL installation, now have spent two days dealing with
this.. this really sucks..) again, thank you for your help..






--
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: all of a sudden can"t connect to server..

On 6/8/06, Frances wrote:
> Daniel da Veiga wrote:
> > On 6/8/06, Frances wrote:
> >
> >> what's event viewer? (searched google for error 1067, so opened .err
> >> file, this is what is says (at the bottom, long file):
> >>
> >> 060607 22:37:33 [Note] mysqld: Shutdown complete
> >>
> >> InnoDB: Error: log file .\ib_logfile0 is of different size 0 10485760
> >> bytes
> >> InnoDB: than specified in the .cnf file 0 5242880 bytes!
> >> 060607 22:47:57 [ERROR] Can't init databases
> >> 060607 22:47:57 [ERROR] Aborting
> >>
> >> 060607 22:47:57 [Note] mysqld.exe: Shutdown complete
> >>
> >> (someone in a MySQL.com forum is also helping me, he suggested changing
> >> this var in my.ini innodb_log_file_size to 20M, which I did, tried again
> >> to restart, same error.. (maybe need to restart machine? you know,
> >> this is all very weird, I never had MySQL server installed as a service
> >> (I think), yet never had to turn it on, never had to do anything or
> >> worry about it in any way, db's were always accessible to me with no
> >> problems..)
> >
> >
> > First of all, understand how MySQL works, at init, it searches for
> > configs in files that can be in numerous location of your disk, mostly
> > they're named "my.cnf" or "my.ini", that if your service does not
> > point at it using "--defaults-file=" on your "Services" windows
> > at MySQL's service properties.
> >
> > Check if you find this file, it was probably ovewritten after you
> > install/uninstall this other app you used, check if it has a
> > configuration named "datadir" and see if it points at your "data"
> > directory. It seems mysql was unable to locate its main database
> > "mysql".
> >
> > Read the manual, the whole installation part, if you understand HOW
> > mysql works you'll be all set. You really need the basis for this to
> > work as we can't see or work with your system directly, only give you
> > advice.
>
> Daniel, thank you very much for your response.. this is what is says in
> manual re .cnf/.ini files:
>
> ----
> In MySQL installations prior to version 4.1.5 it was customary to name
> the server configuration file 'my.cnf' or 'my.ini' and locate the file
> either at 'c:\my.cnf' or 'c:\Windows\my.ini'.
> The new MySQL Configuration Wizard places the 'my.ini' file in the
> installation directory of the MySQL server. This helps associate
> configuration files with particular server instances.
> ----
>
> my.ini is there, but there's no .cnf file.. searched my entire C-drive
> for a my.cnf file, it doesn't exist... (so don't understand why error
> message mentions .cnf file..)

Ok, so, all you have to do is edit the MySQL service adding
"--defaults-file=" and point it to a valid my.ini file with a
datadir variable set to your "data" directory, and you're set. Mysql
now is lost, it can't figure out WHERE to search for defaults.

>
> error I'm getting is can't find my databases, but my databases are all
> there, where they have always been.. ok, where do I go from here

But MySQL don't know where that is. Point it to a valid my.ini and it
will find them.

> please... (would LOVE to know why no warning comes with XAMPP saying it
> can damage existing MySQL installation.. I've never had any problems

Because bad written software installers tend to do stuff like this.
I'm impressed that an app is able to simply delete a service that do
not belong to it without even asking. Reminder to never use such
software.

> whatsoever w/MySQL installation, now have spent two days dealing with
> this.. this really sucks..) again, thank you for your help..

If you check the MySQL Manual at the Installation chapter, you'll find
all you need to start MySQL right. I REALLY recommend you read it and
post back later. To start, if you install MySQL by hand backin up your
current "data" dir, you'll learn a lot and probably will notice how
simple it was to solve this problem.

--
Daniel da Veiga
Computer Operator - RS - Brazil
-----BEGIN GEEK CODE BLOCK-----
Version: 3.1
GCM/IT/P/O d-? s:- a? C++$ UBLA++ P+ L++ E--- W+++$ N o+ K- w O M- V-
PS PE Y PGP- t+ 5 X+++ R+* tv b+ DI+++ D+ G+ e h+ r+ y++
------END GEEK CODE BLOCK------

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

Re: all of a sudden can"t connect to server..

Frances,

On a windows machine, my.cnf will look like a SpeedDial shortcut. You
will not see the extension (.cnf), even if you have set explorer options
to show all file name extensions. Look in the root of your c: drive for
file named "my" that shows a type of SpeedDial, then delete it. Then
look in your windows folder for my.ini. If you have a my.ini in both the
installation folder and the window folder, rename the one in windows (so
you don't lose it. I renamed it 'my.ini.bak'.

Now you only have one configuration file left. Make sure it points to
the correct folder for your data. All of your error messages, and the
entries in your .err file, indicate that mySql can't find the data
directory. This should get you going.

Randy Clamons
Systems Programming
randy@novaspace.com


Frances wrote:
> Daniel da Veiga wrote:
>> On 6/8/06, Frances wrote:
>>
>>> what's event viewer? (searched google for error 1067, so opened .err
>>> file, this is what is says (at the bottom, long file):
>>>
>>> 060607 22:37:33 [Note] mysqld: Shutdown complete
>>>
>>> InnoDB: Error: log file .\ib_logfile0 is of different size 0 10485760
>>> bytes
>>> InnoDB: than specified in the .cnf file 0 5242880 bytes!
>>> 060607 22:47:57 [ERROR] Can't init databases
>>> 060607 22:47:57 [ERROR] Aborting
>>>
>>> 060607 22:47:57 [Note] mysqld.exe: Shutdown complete
>>>
>>> (someone in a MySQL.com forum is also helping me, he suggested changing
>>> this var in my.ini innodb_log_file_size to 20M, which I did, tried again
>>> to restart, same error.. (maybe need to restart machine? you know,
>>> this is all very weird, I never had MySQL server installed as a service
>>> (I think), yet never had to turn it on, never had to do anything or
>>> worry about it in any way, db's were always accessible to me with no
>>> problems..)
>>
>>
>> First of all, understand how MySQL works, at init, it searches for
>> configs in files that can be in numerous location of your disk, mostly
>> they're named "my.cnf" or "my.ini", that if your service does not
>> point at it using "--defaults-file=" on your "Services" windows
>> at MySQL's service properties.
>>
>> Check if you find this file, it was probably ovewritten after you
>> install/uninstall this other app you used, check if it has a
>> configuration named "datadir" and see if it points at your "data"
>> directory. It seems mysql was unable to locate its main database
>> "mysql".
>>
>> Read the manual, the whole installation part, if you understand HOW
>> mysql works you'll be all set. You really need the basis for this to
>> work as we can't see or work with your system directly, only give you
>> advice.
>
> Daniel, thank you very much for your response.. this is what is says in
> manual re .cnf/.ini files:
>
> ----
> In MySQL installations prior to version 4.1.5 it was customary to name
> the server configuration file 'my.cnf' or 'my.ini' and locate the file
> either at 'c:\my.cnf' or 'c:\Windows\my.ini'.
> The new MySQL Configuration Wizard places the 'my.ini' file in the
> installation directory of the MySQL server. This helps associate
> configuration files with particular server instances.
> ----
>
> my.ini is there, but there's no .cnf file.. searched my entire C-drive
> for a my.cnf file, it doesn't exist... (so don't understand why error
> message mentions .cnf file..)
>
> error I'm getting is can't find my databases, but my databases are all
> there, where they have always been.. ok, where do I go from here
> please... (would LOVE to know why no warning comes with XAMPP saying it
> can damage existing MySQL installation.. I've never had any problems
> whatsoever w/MySQL installation, now have spent two days dealing with
> this.. this really sucks..) again, thank you for your help..
>
>
>
>
>
>

--
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: all of a sudden can"t connect to server..

Randy, thank you very much for your help.. in c:\ there are very few
files, it's mostly folders, only thing I came across in c:\ similar to
what you say is a file called tmuninst.ini.... ("SpeedDial"?)

earlier when searched for .cnf in my C-drive come acorss a bunch of
files w/no extension, like you say (icon looks like a computer monitor)
called 'access', 'botinfs', 'bots', etc.. most of them are in
c:\inetpub\wwwroot\_vti_pvt (I have IIS installed..) one of them,
'servers', is in C:\Program Files\Common Files\Microsoft Shared\web
server extensions\40\servsupp... that's it.. apart from this don't see
any .cnf files anywhere.. searched also for my.ini in entire C-drive,
only one is here..

C:\Program Files\MySQL\MySQL Server 4.1

in it I see:

#Path to the database root
datadir="C:/Program Files/MySQL/MySQL Server 4.1/Data/"

it IS pointing to correct location where data is... I DON'T GET
THIS.....:( I still have orig installer, mysql-4.1.9-win32.zip, would
it solve problem, do you think, if I install it again (and it would be
same version, no doubt saving me some more headaches..) can I just back
up data and then put my backed-up db's in Data dir of this new
installation..) this really sucks.. XAMPP should come with a warning
that it messes up existing MySQL installations... again, Randy, many
thanks for your help..

Frances



Randy Clamons wrote:
> Frances,
>
> On a windows machine, my.cnf will look like a SpeedDial shortcut. You
> will not see the extension (.cnf), even if you have set explorer options
> to show all file name extensions. Look in the root of your c: drive for
> file named "my" that shows a type of SpeedDial, then delete it. Then
> look in your windows folder for my.ini. If you have a my.ini in both the
> installation folder and the window folder, rename the one in windows (so
> you don't lose it. I renamed it 'my.ini.bak'.
>
> Now you only have one configuration file left. Make sure it points to
> the correct folder for your data. All of your error messages, and the
> entries in your .err file, indicate that mySql can't find the data
> directory. This should get you going.
>
> Randy Clamons
> Systems Programming
> randy@novaspace.com
>
>
> Frances wrote:
>
>> Daniel da Veiga wrote:
>>
>>> On 6/8/06, Frances wrote:
>>>
>>>> what's event viewer? (searched google for error 1067, so opened .err
>>>> file, this is what is says (at the bottom, long file):
>>>>
>>>> 060607 22:37:33 [Note] mysqld: Shutdown complete
>>>>
>>>> InnoDB: Error: log file .\ib_logfile0 is of different size 0
>>>> 10485760 bytes
>>>> InnoDB: than specified in the .cnf file 0 5242880 bytes!
>>>> 060607 22:47:57 [ERROR] Can't init databases
>>>> 060607 22:47:57 [ERROR] Aborting
>>>>
>>>> 060607 22:47:57 [Note] mysqld.exe: Shutdown complete
>>>>
>>>> (someone in a MySQL.com forum is also helping me, he suggested changing
>>>> this var in my.ini innodb_log_file_size to 20M, which I did, tried
>>>> again
>>>> to restart, same error.. (maybe need to restart machine? you know,
>>>> this is all very weird, I never had MySQL server installed as a service
>>>> (I think), yet never had to turn it on, never had to do anything or
>>>> worry about it in any way, db's were always accessible to me with no
>>>> problems..)
>>>
>>>
>>>
>>> First of all, understand how MySQL works, at init, it searches for
>>> configs in files that can be in numerous location of your disk, mostly
>>> they're named "my.cnf" or "my.ini", that if your service does not
>>> point at it using "--defaults-file=" on your "Services" windows
>>> at MySQL's service properties.
>>>
>>> Check if you find this file, it was probably ovewritten after you
>>> install/uninstall this other app you used, check if it has a
>>> configuration named "datadir" and see if it points at your "data"
>>> directory. It seems mysql was unable to locate its main database
>>> "mysql".
>>>
>>> Read the manual, the whole installation part, if you understand HOW
>>> mysql works you'll be all set. You really need the basis for this to
>>> work as we can't see or work with your system directly, only give you
>>> advice.
>>
>>
>> Daniel, thank you very much for your response.. this is what is says
>> in manual re .cnf/.ini files:
>>
>> ----
>> In MySQL installations prior to version 4.1.5 it was customary to name
>> the server configuration file 'my.cnf' or 'my.ini' and locate the file
>> either at 'c:\my.cnf' or 'c:\Windows\my.ini'.
>> The new MySQL Configuration Wizard places the 'my.ini' file in the
>> installation directory of the MySQL server. This helps associate
>> configuration files with particular server instances.
>> ----
>>
>> my.ini is there, but there's no .cnf file.. searched my entire
>> C-drive for a my.cnf file, it doesn't exist... (so don't understand
>> why error message mentions .cnf file..)
>>
>> error I'm getting is can't find my databases, but my databases are all
>> there, where they have always been.. ok, where do I go from here
>> please... (would LOVE to know why no warning comes with XAMPP saying
>> it can damage existing MySQL installation.. I've never had any
>> problems whatsoever w/MySQL installation, now have spent two days
>> dealing with this.. this really sucks..) again, thank you for your
>> help..
>>
>>
>>
>>
>>
>>
>


--
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: all of a sudden can"t connect to server -- reinstalled..

ok, I had to re-install, had saved orig zip from when first downloaded
(mysql-4.1.9-win32.zip), intallation went ok, but have two problems:

1) can open console client only from DOS shell, if I run mysql.exe from
bin dir it opens quickly then dissapears..

2) can connect ok but can't find tables; for example:

java.sql.SQLException: Can't open file: 'clients.ibd' (errno: 1)

now tables have .frm extension, why is it looking for .ibd tables?
(again, installed exact same version of server I had earlier, just
copied db's back to data dir..) if in console I do describe