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

ok, I had to re-install, had saved orig zip from when first downloaded 
(mysql-4.1.9-win32.zip), intallation went ok, but have two problems:

1) can open console client only from DOS shell, if I run mysql.exe from 
bin dir it opens quickly then dissapears..

2) can connect ok but can't find tables; for example:

   java.sql.SQLException: Can't open file: 'clients.ibd' (errno: 1)

now tables have .frm extension, why is it looking for .ibd tables? 
(again, installed exact same version of server I had earlier, just 
copied db's back to data dir..)  if in console I do describe <table> or 
select * from <table> get told

   ERROR 1016 (HY000): Can't open file: 'clients.ibd' (errno: 1)

(when in fact I can see tables clearly when I do show tables;)

what is the problem here, pls..  thank you very much..

Frances




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