Re: Data directory in 2 platforms

2007-12-27 Thread Micah Stevens
On a dual boot it should work okay. I've done a similar thing, by taking the data folder from a Linux installation, copying it to a local windows computer and using a local install (same version of course) to read it. It worked fine. I would think the scenario is much the same as what you're su

Re: data directory for mysql

2005-06-05 Thread Andras Kende
> Hi all, > > I have been using /var/mysql/data as my data directory till now , > suddenly i realise its all filled up with some 20M left which will > finish in a day or two , repartioning my disks is not an option , what > do i do to restart mysql with a new data directory say > /usr/local/mysql/d

Re: data directory in 4.0.9

2003-01-16 Thread Gelu Gogancea
My dear friend, I suppose that you already done: ./configure --prefix=PATH_OF_THE_MYSQL_APPLICATION After compilation you must do: make install and after this : cd /PATH_OF_THE_MYSQL_APPLICATION/bin and... ./mysql_install_db. Regards, Gelu _ G.N

Re: Data Directory

2002-08-15 Thread Egor Egorov
Daren, Wednesday, August 14, 2002, 11:49:22 PM, you wrote: DC> My Linux installation only has about 1gb in the /var DC> partition, so I need to relocate my databases to the DC> /home partition. I'm pretty sure the following DC> commands will shutdown mysql, move the data directory, DC> create a s

Re: Data Directory

2002-08-14 Thread Daren Cotter
What is the purpose of creating the symlink if I manually edit the data directory variable? Would it be better to: a) Move the data, and edit the data directory to the new location b) Move the data, and create a symlink to the new data TIA, --- Rahadul Kabir <[EMAIL PROTECTED]> wrote: > > >

Re: DATA DIRECTORY bug on Win32

2001-10-29 Thread Michael Widenius
Hi! > "Mike" == Mike Blazer <[EMAIL PROTECTED]> writes: Mike> Miguel Angel SolÕrzano wrote: >> >> At 14:24 24/10/2001 +0400, Mike Blazer wrote: >> Hi Mike, >> >> Thanks for the bug report. >> The explanation why the insert command doesn't works on Win32, >> is because the link file pointi

Re: DATA DIRECTORY bug on Win32

2001-10-29 Thread Michael Widenius
Hi! > "Mike" == Mike Blazer <[EMAIL PROTECTED]> writes: Mike> Well, I'm sure there are some better ways too - it's a pity that it such Mike> a useful feature fails on Win32. >> I have now changed MySQL 4.0.1 to ignore any DATA DIRECTORY >> directives, until we have come up with an accepta

Re: DATA DIRECTORY bug on Win32

2001-10-24 Thread Miguel Angel Solórzano
At 14:24 24/10/2001 +0400, Mike Blazer wrote: Hi Mike, Thanks for the bug report. The explanation why the insert command doesn't works on Win32, is because the link file pointing for the DATA DIRECTORY wasn't created in the create table command, like the Unix version does. The Win32 OSs don't hav

Re: data directory.........

2001-07-28 Thread Steve Brazill
If you had read the installation instructions, you would have seen statements that looked like this... cd /usr/local/mysql ./bin/mysql_install_db Make sure that the "var" directory that is created grants access to the 'user' that MySQL is running as... (otherwise I'm sure we'll be getti

Re: Data Directory

2001-06-13 Thread Gabriele Bartolini
At 14.38 13/06/01 +0530, Suvarsha Walters wrote: >Thanks a lot, > >But another problem. I did the changes in my.cnf and restarted mysql. It >stops immediately, shows the following: > >Starting mysqld daemon with databases from /base1 >010613 14:22:38 mysqld ended > >But when I changed the 'datadi

Re: Data Directory

2001-06-13 Thread Suvarsha Walters
Thanks a lot, But another problem. I did the changes in my.cnf and restarted mysql. It stops immediately, shows the following: Starting mysqld daemon with databases from /base1 010613 14:22:38 mysqld ended But when I changed the 'datadir' values in the my.cnf back to the default directory, it

Re: Data Directory

2001-06-13 Thread Gabriele Bartolini
Ciao! >I am new to both Linux and MySQL. I used the source to >compile MySQL on Linux 7.0 with the default options. >It's working fine. What's Linux 7.0? :-) >But can i change the data directory where all the >databases are stored to something other than the >default, without having to compile