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. Thanks, Anoop On 5/4/05, Gleb Paharenko <[EMAIL PROTECTED]> wrote: > > 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 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 created a file named with the database (same as > > >the > > >folder names that I moved) prefixed with .sym. > > >3. Inside each of these .sym files I enterred (typed) in the exact path > > >of > > >the new folders and nothing else. > > >4. Restarted mysql > > > > > >Now when I give show databases; at the mysql prompt, all my database > > >names > > >are displayed including the ones I moved. > > > > > >Here is the issue: When I use one of the databases that I had moved and > > >give: > > >show tables > > >I am getting an empty set. > > > > > >I know the data is there because the size of the .myd files is 50 MB - > > >well > > >none of the .myi or .frm file is missing or empty! > > >Also I noticed that the .sym files have numbers auto-enterred before the > > >file path I had specified - I guess it is in running mode. > > > > > >So how do I see my tables on the moved databases and query on them?? > > > > > >Thanks in advance, > > >Anoop > > > > > >>>Anoop kumar V <[EMAIL PROTECTED]> wrote: > > -- > For technical support contracts, goto https://order.mysql.com/?ref=ensita > This email is sponsored by Ensita.NET <http://Ensita.NET> > http://www.ensita.net/ > __ ___ ___ ____ __ > / |/ /_ __/ __/ __ \/ / Gleb Paharenko > / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] > /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.NET <http://Ensita.NET> > <___/ www.mysql.com <http://www.mysql.com> > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] > > -- Thanks and best regards, Anoop