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

On 6/9/06, Frances <[email protected]> wrote:
>
> Markus, thank you very much for yr response..  I actually went ahead and
> re-installed..  had same zip that I downloaded originally
> (mysql-4.1.9-win32.zip), so was able to install exact same version I had
> previsously.. only problem is, I had backed up my data, copied my db's
> back to 'data' dir but can't read the tables, either directly from
> console client or programmatically from java.. get this error if do
> describe table, for example:
>
>    ERROR 1016 (HY000): Can't open file: '<tableName>.ibd' (errno: 1)
>
> also can't open console client, only way to run console client is to
> open DOS shell, navigate to bin dir and run it from there..  why is
> this..  (if open console client directly (mysql.exe) it opens very
> briefly but then disappears..)

Of course, if you do not pass any arguments to the client, it simply
try user "root", no password and host "localhost", IF you have this
configured, you enter, else it simply errors and quits (your case).

I'm sincerely quiting on this. You need basic knowledge of MySQL to
work this problem out, and you need to read the docs and understand
what it is, and how it works, else this thread will go on forever
changing from one error message to another.

http://dev.mysql.com/doc/refman/5.0/en/windows-install-archive.html

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