Re: How to move the MySQL data directory?

2006-05-03 Thread Yves Goergen
On 03.05.2006 01:21 (+0100), paul rivers wrote: Specify the data dir in the local my.cnf and be sure your instance uses it by starting it with the --defaults-file parameter set to that instance's local copy. Okay, since hacking seems to be required anyway, I hacked it the straight-forward and

RE: How to move the MySQL data directory?

2006-05-03 Thread Logan, David (SST - Adelaide)
--- -Original Message- From: Yves Goergen [mailto:[EMAIL PROTECTED] Sent: Wednesday, 3 May 2006 8:01 PM To: paul rivers Cc: mysql@lists.mysql.com Subject: Re: How to move the MySQL data directory? On 03.05.2006 01:21 (+0100), paul rivers wrote: Specify the data dir

RE: How to move the MySQL data directory?

2006-05-03 Thread Logan, David (SST - Adelaide)
--- -Original Message- From: Yves Goergen [mailto:[EMAIL PROTECTED] Sent: Wednesday, 3 May 2006 8:01 PM To: paul rivers Cc: mysql@lists.mysql.com Subject: Re: How to move the MySQL data directory? On 03.05.2006 01:21 (+0100), paul rivers wrote

Re: How to move the MySQL data directory?

2006-05-03 Thread Yves Goergen
On 03.05.2006 12:34 (+0100), Logan, David (SST - Adelaide) wrote: You could also have changed the directory in the global /etc/my.cnf file by setting datadir=/path/to/mysql/data This is pretty simple and works a lot easier than hacking the init scripts. As I said, there are two MySQL

Re: How to move the MySQL data directory?

2006-05-03 Thread Jan Pieter Kunst
On 5/2/06, Yves Goergen [EMAIL PROTECTED] wrote: But upgrading MySQL like installing it after MySQL's guide brings a problem: I'd need to move the data directory to the new programme directory every time. That is what I do. I find it easier than moving the data directory to a non-standard

How to move the MySQL data directory?

2006-05-02 Thread Yves Goergen
Hello, I've just wanted to update MySQL 5.0 on my test machine that will be a productive server very soon. But upgrading MySQL like installing it after MySQL's guide brings a problem: I'd need to move the data directory to the new programme directory every time. So I want to move the datadir

Re: How to move the MySQL data directory?

2006-05-02 Thread Yves Goergen
Well, moving the datadir to the new MySQL 5.0.21 directory, messing around with all the stupid symlinks, it seems I have finally managed to delete that datadir... It was empty anyway, yet, but this is an extremely dangerous task. So I really need to move the datadir to a safe place, outside all

Re: How to move the MySQL data directory?

2006-05-02 Thread Dan Buettner
The easiest way might be to tell mysql in the config file where to look for the data directory. In your my.cnf file (typically /etc/my.cnf) under the [mysqld] section: datadir = /Volumes/mysql-data/data Dan -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To

Re: How to move the MySQL data directory?

2006-05-02 Thread Yves Goergen
On 02.05.2006 22:24 (+0100), Dan Buettner wrote: The easiest way might be to tell mysql in the config file where to look for the data directory. In your my.cnf file (typically /etc/my.cnf) under the [mysqld] section: datadir = /Volumes/mysql-data/data One of the main problems with a

RE: How to move the MySQL data directory?

2006-05-02 Thread paul rivers
Buettner Cc: mysql@lists.mysql.com Subject: Re: How to move the MySQL data directory? On 02.05.2006 22:24 (+0100), Dan Buettner wrote: The easiest way might be to tell mysql in the config file where to look for the data directory. In your my.cnf file (typically /etc/my.cnf) under the [mysqld