DongYu Wang wrote:
> Part 1.1Type: Plain Text (text/plain)
I am running mySQL3.21 under Linux RH5.2
I just added another hard disk to the system and want to move my MySQL
database files to the newly added hard disk.
Could anybody tell me how to do that.
I checked the system and could not find my.cnf file.
Thanks in advance
Take the htmlization off your messages. We all like plain text inline
I always do this:
kill -9 `pidof mysqld`
tar cvf /newdrive/var.tar var
tar xvf var.tar
mv var var.old
/etc/rc.d/rc.mysql (where rc.mysql is my mysqld startup command)
Once your mysqld is back up, do a few test queries and make sure
everyone's happy. Afterward, you can toast the /usr/local/var.old
directory (or, burn it to CD, like me) >:)
Linux rocks!!! www.dedserius.com