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

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

Just because its pointing at the right location, doesn't mean the
server knows about it...
Edit the MySQL service under "Control Panel" -> "Administrative Tools"
-> Services and add "--defaults-file=<file>" where <file> is the PATH
TO THE MYSQL OPTIONS FILE. And try to start the server again.

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


-- 
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]