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: | Randy Clamons (ran...@novaspace.com) |
| Date: | 06/08/2006 01:31:48 PM |
| List: | com.mysql.lists.win32 |
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 ran...@novaspace.com
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..