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
