Relocating MYISAM files

[dmcinnis]

Well after a week of trouble shooting, I found out that I cannot add my fulltext index because I am running out of disk space on my /var partition.

Is there a way that I can move my myisam files (database files) from /var/lib/mysql to say /usr/lib/mysql (/usr partition has plenty of space)?

Or is it easier to resize the /var partition? If so how is this done (new to linux)?

Thanks
David

[brandonschnell]

1) stop mysqld (redhat: "/etc/rc.d/rc5.d/S90mysql stop"

2) move the entire mysql directory to /usr/lib/mysql

3) update the mysql start script and set the "datadir" to be the new location for the mysql db files
(ie update: /etc/rc.d/rc5.d/S90mysql, datadir=/usr/lib/mysql)

4) start mysqld (redhat: "/etc/rc.d/rc5.d/S90mysql start")

[[deleted]]

Um... rc5.d...
don't you mean

/etc/rc.d/init.d/mysql?

the files in rcX.d should be symlinks to the files in the /etc/rc.d/init.d directory.

[dmcinnis]

I figured it out.

[dmcinnis]

Thanks.