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). > > 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 > -- Thanks and best regards, Anoop
