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://www.ensita.net/ __ ___ ___ ____ __ / |/ /_ __/ __/ __ \/ / Gleb Paharenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.NET <___/ www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
