Re: all of a sudden can't connect to server.. - Daniel da Veiga - com.mysql.lists.win32

18 messages in com.mysql.lists.win32Re: all of a sudden can't connect to ...

From	Sent On	Attachments
Frances	07 Jun 2006 08:13
Januski, Ken	07 Jun 2006 09:00
Leigh Sharpe	07 Jun 2006 16:21
Frances	07 Jun 2006 19:42
Tobin Cataldo	08 Jun 2006 05:59
Frances	08 Jun 2006 10:06
Tobin Cataldo	08 Jun 2006 10:20
Frances	08 Jun 2006 10:28
Daniel da Veiga	08 Jun 2006 12:55
Frances	08 Jun 2006 13:13
Randy Clamons	08 Jun 2006 13:31
Frances	08 Jun 2006 14:25
Frances	08 Jun 2006 18:01
Daniel da Veiga	08 Jun 2006 18:25
Markus Grossrieder	09 Jun 2006 05:11
Frances	09 Jun 2006 05:54
Daniel da Veiga	09 Jun 2006 06:57
Frances	09 Jun 2006 07:23

Subject:	Re: all of a sudden can't connect to server..
From:	Daniel da Veiga (dani...@gmail.com)
Date:	06/08/2006 06:25:24 PM
List:	com.mysql.lists.win32

On 6/8/06, Frances <fdr...@yahoo.com> 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..

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.

Frances wrote:

Daniel da Veiga wrote:

On 6/8/06, Frances <fdr...@yahoo.com> 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..