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

From: "Frances" <[email protected]>
To: <[email protected]>
Sent: Thursday, June 08, 2006 7:29 PM
Subject: 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

Try 10 MB ...
Default is 5 MB (hence the "specified in the .cnf file 0 5242880 bytes!")

Hope I'm not too late...

Regards, Markus

> 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-service.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 [email protected]
>>>>>> web www.pacificwireless.com.au
>>>>>>
>>>>>> -----Original Message-----
>>>>>> From: Frances [mailto:[email protected]] Sent: Thursday, June 08, 2006 
>>>>>> 1:14 AM
>>>>>> To: [email protected]
>>>>>> 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/[email protected]