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

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]