Is there a way without reinstalling MySQL to change the locations of the
database tables?
For example right now they are in
/var/lib/mysql
I want them
/usr/lib/mysql
Thanks in advance
--
Stephen Johnson
[EMAIL PROTECTED]
http://www.pets4u.com
Owner / Founder
-- your next
PROTECTED]]
Sent: Tuesday, December 18, 2001 10:19 AM
To: MySQL
Subject: Changing the locations of the tables
Is there a way without reinstalling MySQL to change the locations of
the
database tables?
For example right now they are in
/var/lib/mysql
I want them
/usr/lib/mysql
Thanks in advance
the locations of the tables
Is there a way without reinstalling MySQL to change the locations of the
database tables?
For example right now they are in
/var/lib/mysql
I want them
/usr/lib/mysql
Thanks in advance
--
Stephen Johnson
[EMAIL PROTECTED]
http://www.pets4u.com
Owner / Founder
: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
[root@server src]# tar
:19 AM
To: MySQL
Subject: Changing the locations of the tables
Is there a way without reinstalling MySQL to change the locations of the
database tables?
For example right now they are in
/var/lib/mysql
I want them
/usr/lib/mysql
Thanks in advance
--
Stephen Johnson
[EMAIL
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 . shutdown
su
cd /var/lib
tar -cf - mysql | (cd /usr/lib ; tar xvBpf -)
rm -rf mysql
vi
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 ensure