That is what the Bp flags from tar are for, and we did a su beforehand
M
-Original Message-
From: David M. Peak [mailto:[EMAIL PROTECTED]]
Sent: 18 December 2001 18:34
To: [EMAIL PROTECTED]; 'MySQL'
Subject: Re: Changing the locations of the tables
Don't forget to
TED]>
Sent: Tuesday, December 18, 2001 10:24 AM
Subject: RE: Changing the locations of the tables
> I think the key was _without_ reinstalling.
> I emailed this privately first, but should work with minimum downtime
> and preserve data:
>
>
> mysqladmin -u . shutdow
> Here you go:-)
> [root@server src]# rpm -i MySQL-3.XX.XX-1.src.rpm
> [root@server src]# tar -xvzf ../../src/redhat/SOURCES/mysql-3.XX.XX.tar.gz
> [root@server src]# cd mysql-3.XX.XX
> [root@server mysql-3.XX.XX]# ./configure \
> --prefix=/usr/lib/mysql
> [root@server
:x
...restart mysqld.
-Original Message-
From: Bill Blowitz [mailto:[EMAIL PROTECTED]]
Sent: 18 December 2001 17:54
To: 'Stephen Johnson'; 'MySQL'
Subject: RE: Changing the locations of the tables
Here you go:-)
[root@server src]# rpm -i MySQL-3.XX.XX-1.src.rpm
[r
Here you go:-)
[root@server src]# rpm -i MySQL-3.XX.XX-1.src.rpm
[root@server src]# tar -xvzf ../../src/redhat/SOURCES/mysql-3.XX.XX.tar.gz
[root@server src]# cd mysql-3.XX.XX
[root@server mysql-3.XX.XX]# ./configure \
--prefix=/usr/lib/mysql
[root@server mysql-3.XX.XX
Check the MySQL documentation, but I believe there are 2 ways.
1> In the startup of mysqld, set the datadir option, which tells the mysqld
where the tables are.
2> use UNIX links. Using UNIX links is a good way to split your table and
index I/O across disks. Note that you have to be careful abo
