> 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!
He did say "without reinstalling MySQL"... This is
a less drastic way of going about it:
1) Shut down mysqld
2) Copy (don't delete the originals until you're sure
this works) the files to the new location. Make sure
all directory/file permissions are maintained.
3) add or change the 'datadir' directive in mysql.cnf:
[mysqld]
...
datadir=/usr/lib/mysql
...
or on the command line in your startup script:
mysqld --datadir=/usr/lib/mysql
4) restart mysqld.
/ Carsten
--
Carsten H. Pedersen
keeper and maintainer of the bitbybit.dk MySQL FAQ
http://www.bitbybit.dk/mysqlfaq
>
> -----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
