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
[email protected]


Frances wrote:
> Daniel da Veiga wrote:
>> On 6/8/06, Frances <[email protected]> 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=<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/[email protected]