Re: Tables lost in new location of database

2005-05-06 Thread Anoop kumar V
Thank you Gleb, I will try that out and let you know how I did.. Thanks again, Anoop On 5/5/05, Gleb Paharenko <[EMAIL PROTECTED]> wrote: > > Hello. > > Remove mysqld-nt and install mysqld-nt-max. See: > > http://dev.mysql.com/doc/mysql/en/windows-start-service.html > > >jNo - mysqld-nt-max i

Re: Tables lost in new location of database

2005-05-06 Thread Gleb Paharenko
Hello. Remove mysqld-nt and install mysqld-nt-max. See: http://dev.mysql.com/doc/mysql/en/windows-start-service.html >jNo - mysqld-nt-max is not running - I can see in the task manager that >jonly mysqld-nt is running!! >jI also confirmed this by checking in my services - I only have

Re: Tables lost in new location of database

2005-05-05 Thread Anoop kumar V
No - mysqld-nt-max is not running - I can see in the task manager that only mysqld-nt is running!! I also confirmed this by checking in my services - I only have mysqld-nt present as a service for mysql! Should I run mysqld-nt-max for this functionality to work?? Also - I need to run only myisa

Re: Tables lost in new location of database

2005-05-05 Thread Gleb Paharenko
Hello. mysql.exe is a client utility, I've meant the server process. Check that you're running mysqld-max-nt.exe. >I am not sure about max - but I am running mysql.exe (I think it is the >same as mysqld-nt). > >No - when I do a select * from on a table in the moved database - I get >th

Re: Tables lost in new location of database

2005-05-04 Thread Anoop kumar V
Is there a link that someone can suggest which details out how to move databases from one location to another in mysql? Thanks in advance. Anoop On 5/4/05, Anoop kumar V <[EMAIL PROTECTED]> wrote: > > I am not sure about max - but I am running mysql.exe (I think it is the > same as mysqld-nt).

Re: Tables lost in new location of database

2005-05-04 Thread Anoop kumar V
I am not sure about max - but I am running mysql.exe (I think it is the same as mysqld-nt). No - when I do a select * from on a table in the moved database - I get the error that the table does not exist. well - how can i tell if i have disabled symlinks??? I have not checked using 4.1.11. Th

Re: Tables lost in new location of database

2005-05-04 Thread Gleb Paharenko
Hello. Are you sure that you are running mysqld-max (mysqld-max-nt)? Are you able to select data from invisible tables? Is it possible that you have disabled symlinks? Does the problem remain with 4.1.11 version? >I use mysql 4.0.23-nt on win XP. > >In order to shift some of my datab

Tables lost in new location of database

2005-05-03 Thread Anoop kumar V
I use mysql 4.0.23-nt on win XP. In order to shift some of my databases I followed the following steps as per a recent post: 1. I moved the folders containing the database files that I wanted to move to a new folder (from data to data2) after stopping mysql of course. 2. In the data folder I cre