Re: all of a sudden can't connect to server..
Frances <[email protected]>
| Newsgroups | gmane.comp.db.mysql.windows |
|---|---|
| Message-ID | <[email protected]> |
Daniel da Veiga wrote: > 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 ok, thanks Daniel.. I remember from last time I didn't pass anything to client, opened client, typed password, got in... (as far as reading tables, I HAVE searched google for "mysql copy databases", etc.. still can't find out how to solve that problem.. can't understand why can't read tables, have exact same version as before, why can't MySQL read my tables now..) ok, thanks anyway... since have spent three days already trying to solve this problem what's one day more....?? ;) -- MySQL Windows Mailing List For list archives: http://lists.mysql.com/win32 To unsubscribe: http://lists.mysql.com/[email protected]