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 that the account that the mysqld is running under has the proper permissions to the new directory. I ran into that one before.. ----- Original Message ----- From: "Matthew Smith" <[EMAIL PROTECTED]> To: "'MySQL'" <[EMAIL PROTECTED]> 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 ..... shutdown > su > cd /var/lib > tar -cf - mysql | (cd /usr/lib ; tar xvBpf -) > rm -rf mysql > > vi /etc/my.cnf > :%s/\/var\/lib\/mysql/\/usr\/lib\/mysql/g > :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 -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]# make > [root@server mysql-3.XX.XX]# make install > [root@server mysql-3.XX.XX]# scripts/mysql_install_db > > XX.XX is your mysql version > > Good Luck! > > -----Original Message----- > From: Stephen Johnson [mailto:[EMAIL PROTECTED]] > Sent: Tuesday, December 18, 2001 9: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 PROTECTED] > http://www.pets4u.com > Owner / Founder > **** > -- your next best friend is waiting for you -- > > > > --------------------------------------------------------------------- > Before posting, please check: > http://www.mysql.com/manual.php (the manual) > http://lists.mysql.com/ (the list archive) > > To request this thread, e-mail <[EMAIL PROTECTED]> > To unsubscribe, e-mail > <[EMAIL PROTECTED]> > Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php > > > --------------------------------------------------------------------- > Before posting, please check: > http://www.mysql.com/manual.php (the manual) > http://lists.mysql.com/ (the list archive) > > To request this thread, e-mail <[EMAIL PROTECTED]> > To unsubscribe, e-mail <[EMAIL PROTECTED]> > Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php > --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php