Moving database files to larger partition?

2006-06-05 Thread Jay Paulson
I'm currently setting up MySQL 4.1.2 on RHEL 4.1 and I have found the
/etc/my.cnf file.  I'm trying to find out if I change the basedir from:

Basedir=/var/lib

To

Basedir=/other/path

Will that move the actual data files that have all my databases?  Do I need
to move any of the things that are in /var/lib over to the new path or just
the data files of my databases?

Thanks!

-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]



Re: Moving database files to larger partition?

2006-06-05 Thread Daniel da Veiga

On 6/5/06, Jay Paulson [EMAIL PROTECTED] wrote:

I'm currently setting up MySQL 4.1.2 on RHEL 4.1 and I have found the
/etc/my.cnf file.  I'm trying to find out if I change the basedir from:

Basedir=/var/lib

To

Basedir=/other/path

Will that move the actual data files that have all my databases?  Do I need


No, MySQL will simply go there looking for files as it starts, if it
don't find any, it will crash. MySQL needs at least the mysql database
to work.


to move any of the things that are in /var/lib over to the new path or just
the data files of my databases?



If you're not changing versions, move the whole dir (/var/lib/mysql)
to the new location, simple as that, but you must do it yourself,
cause MySQL won't.


--
Daniel da Veiga
Computer Operator - RS - Brazil
-BEGIN GEEK CODE BLOCK-
Version: 3.1
GCM/IT/P/O d-? s:- a? C++$ UBLA++ P+ L++ E--- W+++$ N o+ K- w O M- V-
PS PE Y PGP- t+ 5 X+++ R+* tv b+ DI+++ D+ G+ e h+ r+ y++
--END GEEK CODE BLOCK--

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]