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

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