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

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