> 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

Reply via email to