Off the top of my head....:) In the my.cnf file under the [mysqld] section add the following line:
datadir= /path.to/new/datadir Stop mysql. Move all dbs to new datadir (if your'e only using MYISAM, this is a straight copy). Restart mysql. HTH Rory McKinley Nebula Solutions +27 82 857 2391 [EMAIL PROTECTED] "There are 10 kinds of people in this world, those who understand binary and those who don't" (Unknown) ----- Original Message ----- From: "David Wilson" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Wednesday, October 22, 2003 5:49 PM Subject: Moving databases We are running MySQL 3.23.47 on a AIX Risc System. It is IBM's compiled version of MySQL, it does everything as far as installing and compiling it for us. But what we found is that is stores the databases where it wants and would like to move them but cant seem to figure it out. Does anybody have a clue -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
